Forum Discussion

DougCrandall's avatar
DougCrandall
Qrew Member
3 years ago

Using a formula to show a negative value in a Summary report

Greetings all,

I have a table with a Port Type (Port In or Port Out) text field and Carrier text field. I have built a summary report summarizing the port type (ports in and ports out) by carrier.

For the ports out, I want to have that be a negative number so my totals column ends up showing a net of ports in and out.

I tried to build a report formula using an IF statement to make Ports Out negative: -(If([Port Type]="Port Out", 1)). However, that didn't work. Then I tried to define summary variables for Ports In and Ports Out summarized by totals then write a summary report formula subtracting ports out from ports in, but still no luck.

Can anyone tell me if what I want to do is possible using summary report formulas or do I need to go about it a different way?

------------------------------
Doug Crandall
------------------------------

4 Replies

  • You should be able to create a real field or a report field like this

    If([Port Type]="Port Out", -1,1)


    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • DougCrandall's avatar
      DougCrandall
      Qrew Member
      Thanks Mark. I had tried that formula as well earlier without success, other than it changed my column headings to '1' and '-1'.

      Am I not putting the formula in the right place?


      ------------------------------
      Doug Crandall
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        You should change what you are summarizing to be that formula field.  Rights now you are counting records. 

        Instead summarize the total of the formula field which would be called something like Net Port Counts.

        ------------------------------
        Mark Shnier (YQC)
        Quick Base Solution Provider
        Your Quick Base Coach
        http://QuickBaseCoach.com
        mark.shnier@gmail.com
        ------------------------------