Management reporter currently calculates Actual - Budget. However, for "Burn Rate", I need it to calculate Budget - Actual, and for "Sales", I need it to calculate Actual - Budget.
Does anyone have any suggestions on how to change the column formula for specific rows?
Thank you
*This post is locked for comments
Your best bet would be to use and IF THEN ELSE statement. You will have to find something that is unique to your burn rate column though so it may need tweaking each month.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (