Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Calculated fields RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

  • Question
    Sign in to vote
    0
    Sign in to vote

    HI,

    -1 should be within brakets like:

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


    Friday, June 19, 2015 6:52 AM