Skip to Content
0
Former Member
Apr 22, 2010 at 08:36 AM

The following syntax error occurred during parsing: Invalid token, Line 1,

2292 Views

Hello Experts,

I hope someone could help me. I am trying to create a MDX formula in Account dimension (Cuenta).

When formula created use "Iif" syntax, system give the following error:

- [CUENTA].[H1].[#X000] Parser: The following syntax error occurred during parsing: Invalid token, Line 1, Offset 15, [.

My Account dimension (Cuenta) has 3 parent, and the formula introduces is:

'Iif([Cuenta].[H1].[BLOQ_FASEC]<0.5 and [Cuenta].[H1].[BLOQ_FASEC]>-0.5,0,[Cuenta].[H1].[BLOQ_FASEC])

We try another syntax

'Iif([Cuenta].[BLOQ_FASEC]<0.5 and [Cuenta].[BLOQ_FASEC]>-0.5,0,[Cuenta].[BLOQ_FASEC])

But same error persist.

Could you have any idea?

Thanks