Skip to Content
0
Nov 14, 2012 at 09:10 AM

*IIF statement

1459 Views

Hi,

I am trying to accumalate several accounts using *when statement, and *IIF statement on entity. It is throwing error.

My code looks like

*XDIM_MEMBERSET ACCOUNT= BAS(W439100)

*XDIM_MEMBERSET RPTCURRENCY = LC,USD

*XDIM_MEMBERSET ENTITY = %ENTITY_SET%

*XDIM_MEMBERSET CATEGORY = %CATEGORY_SET%

*XDIM_MEMBERSET DATASRC=INPUT

*XDIM_MEMBERSET MEASURES=PERIODIC

*XDIM_MEMBERSET TIME = 2013.TOTAL

*WHEN ACCOUNT

*IS BAS(W439100)

*IIF([ENTITY].[GL_TYPE]=GL_2_INT,*REC(EXPRESSION=%VALUE%,ACCOUNT="439110"), *REC(EXPRESSION=%VALUE%,ACCOUNT="439100"))

*ENDWHEN

it is giving an error during validation

UJK_VALIDATION_EXCEPTION:Unknown or unimplemented keyword "*IIF([ENTITY].[GL_TYPE]=GL_2_INT,*REC(EXPRESSION=%"

Isn't it possible to use IIF condition on entity if we use account in when condition?

your inputs are highly appreciated.

thanks,

ravi.