Discussions
How do I write a NSPB annual assumption member formula to calculate per employee for one month?
I am creating a new NSPB annual assumption for a Christmas Bonus. How do I write a NSPB annual assumption member formula to calculate per employee for just the month of December? I've already created the account dimension for the annual assumption label and the Christmas Bonus field that loads on the employee review. My current member formula is calculating by employee, but it's also calculating every month, which is not what we want. Here is my formula:
IF ("Status" ==1 )"Christmas Annual Bonus"->"BegBalance"->"No_Department"->"No_Employee"->"No Office"->"No Currency";
ELSE
#Missing;
ENDIF