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
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
    ------------------------------