IIF with formatting

Comments

• gordk St.Catherines On. Canada.

  September 2010 edited 6:06PM

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

  September 2010 edited 6:06PM

  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

  September 2010 edited 6:06PM

  Well GordK You??re right.
  
  This is the solution:
  
  [*<IIF(<SKV953P."EKEPREIS"><>0,<SKV953P."EPREIS"> / <SKV953P."EKEPREIS">,'') #n%2,2n>*]
  
  
  
  Best regards
  
  Erik