Discussions

Expand all | Collapse all

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

  • 1.  Using a formula to show a negative value in a Summary report

    Posted 8 days ago
    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
    ------------------------------


  • 2.  RE: Using a formula to show a negative value in a Summary report

    Posted 8 days ago
    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
    ------------------------------



  • 3.  RE: Using a formula to show a negative value in a Summary report

    Posted 8 days ago
    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
    ------------------------------



  • 4.  RE: Using a formula to show a negative value in a Summary report

    Posted 8 days ago
    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
    ------------------------------



  • 5.  RE: Using a formula to show a negative value in a Summary report

    Posted 8 days ago
    Doh! Thank you Mark. That worked perfectly.

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