Variance Amounts
I'm trying to write a report that computes variance, but does it in a better/(worse) result. We have defined our Revenue accounts as "Revenue" then we flip the sign so it doesn't show as "(xxxxxx)" and our expenses are defined as "expenses". When I do a normal PTD-Variance definition, by subtracting Col 2 from Col 1, Revenue works great but Expenses are the wrong way. For example, Oracle currently does it this way:
Revenue:
Period 1 - 1,000,000
Period 2 - 900,000
Variance - 100,000 (showed this way as its a better result)
Expenses:
Period 1 - 1,000,000
Period 2- 900,000
Variance 100,000 (Shows as a positive increase, but I want it to show as (100,000) since expenses growing is a worse scenario.
0