Receiving the error message below:
Error: 1200416 Error executing formula for [AccountMemberName] (line 0): Cannot assign [DOUBLE] objects of different length
I have added the following member formula to a dense Account member name. {purpose: I have created an account called S_BegBalance to hold data codes for headcount. So, if the S_BegBalance = 1, headcount should be 1 for all the year (Jan-Dec). If the S_Beg Balance = 2, headcount is Feb-Dc, for S_BegBalance =3, headcount is Mar - Dec.
Headcount is a store member(dense) S_BegBalance is also a dense member store.
[Please advise whY ai receivng this error? Can I take care of this with calc script only?]
Calc script to calc the member formula and aggregate the calc is :
FIX("FYxx","Scenario","Version")
FIX(@LEVMBRS(Product,0),@LEVMBRS(Entities,0),@LEVMBRS(Region,0),@LEVMBRS(Position,0))
@DESCENDANTS("AccountParentMember");
ENDFIX
CALC DIM(Entities,Region,Position);
ENDFIX
******Member formula
IF (@ISMBR("Budget") AND @ISMBR("1st Pass - Budget"))
IF (@ISMBR("FY14") AND ("S_BegBalance" == 1))
@IDESC("YearTotal") = "Headcount" == 1;
END IF
IF (@ISMBR("Budget") AND @ISMBR("1st Pass - Budget"))
IF (@ISMBR("FY14") AND ("S_BegBalance" == 2))
"Feb" = "Headcount" == 1;
"Mar" = "Headcount" == 1;
@IDESC("Q2") = "Headcount" == 1;
@IDESC("Q3") = "Headcount" == 1;
@IDESC("Q4") = "Headcount" == 1;
END IF
ELSEIF (@ISMBR("FY14") AND ("S_BegBalance" == 3))
"Mar" = "Headcount" == 1;
@IDESC("Q2") = "Headcount" == 1;
@IDESC("Q3") = "Headcount" == 1;
@IDESC("Q4") = "Headcount" == 1;
ELSEIF (@ISMBR("FY14") AND ("S_BegBalance" == 4))
@IDESC("Q2") = "Headcount" == 1;
@IDESC("Q3") = "Headcount" == 1;
@IDESC("Q4") = "Headcount" == 1;
ELSEIF (@ISMBR("FY14") AND ("S_BegBalance" == 5))
"May" = "Headcount" == 1;
"Jun" = "Headcount" == 1;
@IDESC("Q3") = "Headcount" == 1;
@IDESC("Q4") = "Headcount" == 1;
ELSEIF (@ISMBR("FY14") AND ("S_BegBalance" == 6))
"Jun" = "Headcount" == 1;
@IDESC("Q3") = "Headcount" == 1;
@IDESC("Q4") = "Headcount" == 1;
ELSEIF (@ISMBR("FY14") AND ("S_BegBalance" == 7))
@IDESC("Q3") = "Headcount" == 1;
@IDESC("Q4") = "Headcount" == 1;
ELSEIF (@ISMBR("FY14") AND ("S_BegBalance" == 8))
"Aug" = "Headcount" == 1;
"Sep" = "Headcount" == 1;
@IDESC("Q4") = "Headcount" == 1;
ELSEIF (@ISMBR("FY14") AND ("S_BegBalance" == 9))
"Sep" = "Headcount" == 1;
@IDESC("Q4") = "Headcount" == 1;
ELSEIF (@ISMBR("FY14") AND ("S_BegBalance" == 10))
@IDESC("Q4") = "Headcount" == 1;
ELSEIF (@ISMBR("FY14") AND ("S_BegBalance" == 11))
"Nov" = "Headcount" == 1;
"Dec" = "Headcount" == 1;
ELSEIF (@ISMBR("FY14") AND ("S_BegBalance" == 12))
"Dec" = "Headcount" == 1;
ENDIF
I edited the formula to find where is the error?
IF (@ISMBR("Budget") AND ("S_BegBalance" == 1) AND @ISMBR("1st Pass - Budget") AND @ISMBR("FY14"))
@IDESC("YearTotal") = "Headcount" == 1;
ENDIF
IF (@ISMBR("Budget") AND ("S_BegBalance" == 2) AND @ISMBR("1st Pass - Budget") AND @ISMBR("FY14"))
@IDESC("Q2") = "Headcount" == 1;
@IDESC("Q3") = "Headcount" == 1;
@IDESC("Q4") = "Headcount" == 1;
"Feb" = "Headcount" == 1;
"Mar" = "Headcount" == 1;
ENDIF