Forum Discussion

DanSupport_'s avatar
DanSupport_
Quickbase Staff
9 years ago

Converting numbers to negative

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?
  • DanSupport_'s avatar
    DanSupport_
    Quickbase Staff
    9 years ago
    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.