variance Calculation
EbeyDec 10 2010 — edited Dec 15 2010Hi All,
I am using Hyperion Financial Repor 11.1.1.3. I have colume A for Actual, colume B for Variance Percentage. In Row Accounts and corresponding entity.
The calculation is like this.
Actual Value (Colume A) / particular amount (Cell(14,A))*100
I tried like this Col[A]/Cell(14,A)*100. But not showing any error, value not coming.
Please suggest me any wrong in report design or in formula.
Thank You
EP