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):
Tagged:
0