How to count the number of different employee types in Hyperion Planning.
Dear All,
Can you please advise how to count the number of different employee types in Hyperion Planning. I'm trying to use a member formula as follows -
If ("Employee Type"->"BegBalance"==1
or "Employee Type"->"BegBalance"==2
or "Employee Type"->"BegBalance"==3
or "Employee Type"->"BegBalance"==4)
"Driver1"+1;
else
0;
Endif
It always goes to the else though the members exist with Employee Type 1,2,3,4.
Thanks in advance.