IIF with format

edited 6:52AM in FastReport 4.0
Hi there,

i like to have an IIF statement with formatting.

Soemthing like.

IIF(<STable."Amount"> <> Null, <STable."Amount"> #n%2,2f, '')

But if i use the upper example it says "error ')' expected"



Any suggestions ?


Regards
Erik

Comments

  • edited 6:52AM
    Hi.

    I think you should be able to use the 'Format'-function inside the IIF.


    Petter
  • edited 6:52AM

    IIF(<STable."Amount"> <> Null, Format('%n', [<STable."Amount">]), '')

  • edited 6:52AM
    Thank You Petter,

    that was what I needed.

    Regards
    Erik

Leave a Comment

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.