Forum Discussion

BibhavRimal's avatar
BibhavRimal
Qrew Trainee
2 years ago

Convert negative numbers to positive from a report

Hi,  I have a report and one column shows negative values. Is there a way to convert that column to so that it shows positive values? Thank you! ------------------------------ Bibhav Rimal ...
MarkShnier__You's avatar
MarkShnier__You
Qrew Champion
2 years ago
You can make a new formula numeric field  with the formula,

abs([my field])

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
  • BibhavRimal's avatar
    BibhavRimal
    Qrew Trainee
    2 years ago
    Is there a way to do that within the report rather than creating a new formula field?

    ------------------------------
    Bibhav Rimal
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Qrew Champion
      2 years ago
      If the columns are not set to default, then you can create up to three 

      "Report Formulas"

      which only exist on that report.

      ------------------------------
      Mark Shnier (Your Quickbase Coach)
      mark.shnier@gmail.com
      ------------------------------