Skip to Main Content

How to hide a column in HFM web form?

user11980961Jun 16 2017 — edited Jun 26 2017

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

Comments