Skip to main content
Question

Converting numbers to negative

  • March 2, 2017
  • 0 replies
  • 45 views
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?
      This topic has been closed for replies.

      • DanSupport
      • Author
      • Quickbase Staff
      • March 2, 2017
      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.

      Terms & ConditionsAccessibility statement