locked
Calculated fields RRS feed

  • Question

  • Im trying to create a calculated field that returns a decimal as a negative number

    = (new_balanccebf + new_totalcredits + new_totaldebits  - new_retained) 

    the above works but returns a positive number, I want to retuen it as a negative, but if I try

    (new_balanccebf + new_totalcredits + new_totaldebits  - new_retained) * -1

    it says the formula is invalid


    Dont ask me .. i dont know

    Wednesday, June 17, 2015 5:59 PM

Answers

  • HI,

    -1 should be within brakets like:

    (new_balanccebf + new_totalcredits + new_totaldebits  - new_retained) *( -1 )


    Friday, June 19, 2015 6:52 AM