Converting numbers to negative
Original post: Asked by Arshad 25 days ago I have a report where I am summarising stores by FY. There are stores we are adding or there stores we are closing. There is a development ...
Forum Discussion
Answer
No problem, Just make a formula numeric field called perhaps [Net Store Openings] that calculates +1 if the event was the store opening and calculates to -1 if the event was a store closing. Then make a summary report based on that field.
Was this answer helpful?
Answered by:
QuickBaseCoach App Dev./Training , Mark Shnier, Principal
QuickBase Solution Provider 25 days ago
2 comments
No problem, Just make a formula numeric field called perhaps [Net Store Openings] that calculates +1 if the event was the store opening and calculates to -1 if the event was a store closing. Then make a summary report based on that field.
Was this answer helpful?
Answered by:
QuickBaseCoach App Dev./Training , Mark Shnier, Principal
QuickBase Solution Provider 25 days ago
2 comments
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.
- Arshad
- 24 days ago
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.
- QuickBaseCoach App Dev./Training
- 24 days ago