IIF with formatting

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

Comments

  • gordkgordk St.Catherines On. Canada.
    edited 3:04AM
    try moving the format tag and the format to come after the last delimiter
  • edited 3:04AM
    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.
  • edited 3:04AM
    Well GordK You??re right.

    This is the solution:

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



    Best regards

    Erik

Leave a Comment