BPC Member formula gives Admin module error

[Pawan_Mahto]

Hi,

We have 3 elements in dimension APL_GRADE: Officer, Executive, Manager.

I have to write a member formula for APL_CATEGORY dimension element 'Revised Total Proposed Cost'(REV_TOT_PROP_COST) which has logic that if APL_GRADE is officer the formula should be as below count*CTC amount *(75/100) else count*CTC*amount*1:

I have tried to add the below formula with IIF([APL_GRADE].CURRENTMEMBER.PROPERTIES("GRADECATEGORY") = "OFFICER") but it is giving me an internal error

(([APL_CATEGORY].[ACT_CY],[APL_KEYFIGURE].[COUNT]) + ([APL_CATEGORY].[ADJ],[APL_KEYFIGURE].[COUNT]) + ([APL_CATEGORY].[PROP_ADD_DEL],[APL_KEYFIGURE].[COUNT]))*(([APL_CATEGORY].[AVG_CTC_ACT_CY],[APL_KEYFIGURE].[AMT])*(((([APL_CATEGORY].[INFL_PERC],[APL_KEYFIGURE].[AMT])+100)/100))) * (75/100))


if  the grade is not officer i.e it is Executive or manager then this formula where there is no multiply with 75 %:

((([APL_CATEGORY].[ACT_CY],[APL_KEYFIGURE].[COUNT]) + ([APL_CATEGORY].[ADJ],[APL_KEYFIGURE].[COUNT]) + ([APL_CATEGORY].[PROP_ADD_DEL],[APL_KEYFIGURE].[COUNT]))*(([APL_CATEGORY].[AVG_CTC_ACT_CY],[APL_KEYFIGURE].[AMT])*(((([APL_CATEGORY].[INFL_PERC],[APL_KEYFIGURE].[AMT])+100)/100))))

[former_member186338]

Sorry, but are you sure that the error is related to this formula:

IIF([APL_GRADE].CURRENTMEMBER.PROPERTIES("GRADECATEGORY")="OFFICER",10,20)

If you remove this formula - no error?

Do you have correct property name GRADECATEGORY? Correct case?

Do you have some model where you have APL_CATEGORY dimension, but not APL_GRADE dimension??

[former_member186338]

Not sure that you have correct number of brackets...
Start with simple formula:

IIF([APL_GRADE].CURRENTMEMBER.PROPERTIES("GRADECATEGORY")="OFFICER",10,20)

Is it working?

[Pawan_Mahto]

getting internal set error while processing above formula