Hello All,
I have a requirement of calculating variance % in columns for number of accounts.
C1=A#account1.Y#@Cur.P#@Cur
C2=A#account2.Y#@Cur(-1).P#@Cur
C3=Scalc(((C1-C2)/C2)*100), CustomHeader:Variance %
How can i hide columns C1 and C2 in HFM web form?
My second question is:
Can i have Scalc formula like below?
C3=Scalc((((A#account1.Y#@Cur.P#@Cur)-(A#account2.Y#@Cur(-1).P#@Cur))/(A#account2.Y#@Cur(-1).P#@Cur))*100), CustomHeader:Variance %
But i am getting error with this formula.
I would be grateful if you can help me in this matter.
Hyperion version is 11.1.2.4