Discussions

 View Only
  • 1.  Convert negative numbers to positive from a report

    Posted 01-31-2023 11:25
    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
    ------------------------------


  • 2.  RE: Convert negative numbers to positive from a report

    Posted 01-31-2023 11:27
    You can make a new formula numeric field  with the formula,

    abs([my field])

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



  • 3.  RE: Convert negative numbers to positive from a report

    Posted 01-31-2023 11:58
    Is there a way to do that within the report rather than creating a new formula field?

    ------------------------------
    Bibhav Rimal
    ------------------------------



  • 4.  RE: Convert negative numbers to positive from a report

    Posted 01-31-2023 12:02
    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
    ------------------------------