Hi,
I am trying to setup a financial report template for a client and I am trying to have a different formula for the expenses. Currently, the budget variance is currently set to subtract the Budget amount from the YTD amount. However, they would like to have it set the opposite for only expenses. Is there a way to achieve this?
Thank you,
Joey
Best answer by Laura02
Hello,
I have an idea. I wonder whether Row Code can be used to identify rows that are Expenses versus Income, like this:
Instead of the default: =(E-F)/E
Try”
=iif(@RowCode >='0200', (E-F)/E, (F-E)/E)
P & L can have Income , then Expenses, then more income & expenses… so you may need to expand the Row numbers.
Laura
+19Hello,
I have an idea. I wonder whether Row Code can be used to identify rows that are Expenses versus Income, like this:
Instead of the default: =(E-F)/E
Try”
=iif(@RowCode >='0200', (E-F)/E, (F-E)/E)
P & L can have Income , then Expenses, then more income & expenses… so you may need to expand the Row numbers.
Laura
+19I’m so glad it works!
Laura
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
