You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How can I return a negative value when using the "difference" formula

Summary: I am trying to prepare an income statement. In the current year expenses are greater than revenues. The formula I am using is "round(difference(row[21], row[9]),0)" The result is the absolute value, but I don't want the absolute value, I want a negative value. I added a - in front of round to obtain a negative value, but this seems like a workaround, because it impact all the columns which I don't want. Is there a way to get it to subtract correctly? ie. 2-3=-1


Content (required):


Version (include the version you are using, if applicable):


Code Snippet (add any code snippets that support your topic, if applicable):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!