IIF functions: any samples available?
I try to get IIF expressions to work, but without result.
I get all sorts of variations on stuff the expression seems to miss (),],;,"), and believe me I have tried every variation I could think of.
What do I have to do to get
IIF([DialogForm.Query_Plaatsingsopdracht."FC_INZENDSTATUS"]= 'I', 'Nieuw advertentiemateriaal wordt u toegezonden', 'Herplaatsing van '+ [ [FORMATDATETIME('DD-MM-YYYY', DialogForm.Query_Plaatsingsopdracht."FD_INZENDDATUM") ] )]
to work?
Even as simple as IIF( <1=1> , "Hello 1" , "hello 2 " ) (all variations with ({["; tried) does not compute?
I get all sorts of variations on stuff the expression seems to miss (),],;,"), and believe me I have tried every variation I could think of.
What do I have to do to get
IIF([DialogForm.Query_Plaatsingsopdracht."FC_INZENDSTATUS"]= 'I', 'Nieuw advertentiemateriaal wordt u toegezonden', 'Herplaatsing van '+ [ [FORMATDATETIME('DD-MM-YYYY', DialogForm.Query_Plaatsingsopdracht."FD_INZENDDATUM") ] )]
to work?
Even as simple as IIF( <1=1> , "Hello 1" , "hello 2 " ) (all variations with ({["; tried) does not compute?
Comments
enclosing the expression
[IIF(,,)]
so
[iif(test expression equates to true, then use this, else use this)]
it also looks like you are trying to use fr2 code as the query would not be on a dialog in fr4.
Also: can i combine multiple IIF 's?
like
IIF( x=1 , 'we have 1', IIF( x=2, 'we have 2', 'too many' ) )
??
VisitID
1234
0
1235
0126
0
1238
4
The answer I need is 4 Excluding 0 in the Group Footer using Totals
I can use this in the control column like but how can I use in the Summary or Group Footer
Can I use something like: If Yes How appreciate your help
Thanks