IIF with format
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
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
I think you should be able to use the 'Format'-function inside the IIF.
Petter
IIF(<STable."Amount"> <> Null, Format('%n', [<STable."Amount">]), '')
that was what I needed.
Regards
Erik