Converting numbers to negative

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
Original post:

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 type we use to categorise. Is there a possibility that we could create a summary report where all closures are denoted as negative number to get the right summary totals?
Photo of Dan G. (QB Support)

Dan G. (QB Support), Official Rep

  • 490 Points 250 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of Dan G. (QB Support)

Dan G. (QB Support), Official Rep

  • 490 Points 250 badge 2x thumb
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:
Original
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.


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.