Thanks. This is a good solution to calculate net position. As I need to show actual number of closed and opened, in the summary I would still need to denote my closures as negative. Any option to achieve that.
You can summarize a field that calculates a to 1 if a store were opened and then summarize a different field which calculates to 1 when a store is closed and then also summarize the net field.