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

3 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew #1 Challenger
    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 #1 Challenger
        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
        ------------------------------