Discussions

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

    Posted 06-07-2021 16:07
    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 06-07-2021 17:05
    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 06-07-2021 17:25
    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 06-07-2021 17:28
    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 06-07-2021 17:32
    Doh! Thank you Mark. That worked perfectly.

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