You’re offline. This is a read only version of the page.
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.
Share
Report
All responses (
Answers (
