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
Is there a ways to do it without having he modify the report every month? lets say by setting the row?
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.
André Arnaud de Cal... 291,134 Super User 2024 Season 2
Martin Dráb 229,928 Most Valuable Professional
nmaenpaa 101,156