IIF with formatting

reimers

Hi,

I want to use an IIF-Statement with formatting the result.

This works fine:

[*<IIF(<SKV953P."EKEPREIS"><>0,<SKV953P."EPREIS"> / <SKV953P."EKEPREIS">,'')>*]


But now I want to format the result like this:

[*<IIF(<SKV953P."EKEPREIS"><>0,<SKV953P."EPREIS"> / <SKV953P."EKEPREIS"> #n%2,2n,'')>*]

With this I get an error that ')' is missing.



My ExpressionDelimiters are: [*<,>*]
I uses FR 4.9.102



What can I do ?????????????



Regards
Erik

gordk

try moving the format tag and the format to come after the last delimiter

Kipow

reimers wrote: »

Hi,

I want to use an IIF-Statement with formatting the result.

This works fine:

[*<IIF(<SKV953P."EKEPREIS"><>0,<SKV953P."EPREIS"> / <SKV953P."EKEPREIS">,'')>*]


But now I want to format the result like this:

[*<IIF(<SKV953P."EKEPREIS"><>0,<SKV953P."EPREIS"> / <SKV953P."EKEPREIS"> #n%2,2n,[size="14px"]''[/size])>*]

With this I get an error that ')' is missing.



My ExpressionDelimiters are: [*<,>*]
I uses FR 4.9.102



What can I do ?????????????



Regards
Erik

I think the double quote don't have to be there.

reimers

Well GordK You??re right.

This is the solution:

[*<IIF(<SKV953P."EKEPREIS"><>0,<SKV953P."EPREIS"> / <SKV953P."EKEPREIS">,'') #n%2,2n>*]



Best regards

Erik