Hi Omkar,
this is the thing.
I have a column set with 3 members (Actual, Budget, Var_Scen),
where Variance is calculated as follows:
If AccountType = "Expense" then
Variance = (Actual - Budget)
else
Variance = (Budget - Actual)
The goal is implement a Guided_Reporting ColumnSet, so I don't know the accounts in the RowSet.
Thanks,
Rafael Vidal
Raphael - to answer your most recent comment, try using the BWDiff member filter to calculate the variance, rather than trying to flip the sign on the expense accounts. BWDiff will inherently calculate the variance based on account type (revenue, expense, etc.).
