5
Hello, I am trying to prepare a simple variance report with a column definition that shows a +Favorable and -Unfavorable variance.
The following are my rows:
Revenue
COGS
Expense
The following are my columns
Budget, Actual, Variance
In my Variance column, how do I have the following formulas restricted to specific rows?
Revenue = Actual - Budget
COGS / Expense = Budget - Actual
MR doesn't allow you to restrict columns to row. But, you can restrict a row to a certain column. Let's say that Column D has a calculation that is the Actual column - the Budget column. In the row definition, I could restrict a row to only appear in Column D by using the Column Restriction column. By place "D" in there, that row would only appear in Column D.
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,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
