Forum Discussion

DougCrandall's avatar
DougCrandall
Qrew Cadet
4 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. ...
Formulas and functions
reports and charts
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
4 years 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
------------------------------
DougCrandall's avatar
DougCrandall
Qrew Cadet
4 years 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
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    4 years 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
    ------------------------------
    • DougCrandall's avatar
      DougCrandall
      Qrew Cadet
      4 years ago
      Doh! Thank you Mark. That worked perfectly.

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