Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi experts
I need to fill a new field "compliant". Only one field "Field A" should be in the condition.
(If([Field A] = '0', '0') OR IF([Field A] = '3', '3') OR If([Field A] = '4', '4') OR If([Field A] = '5', '5')) as [Compliant],
Unfortunately the result in the app shows "-1" , and not the required value in the conditions.
Can you plesae support and help?
Many thanks
Tom
By the looks of it you don't need to use multiple if's.
Try this:
/*If Field A is 0,3,4 or 5 then use the value of Field A */
If( match([Field A], '0', '3','4','5'), [Field A]) as [Compliant],
By the looks of it you don't need to use multiple if's.
Try this:
/*If Field A is 0,3,4 or 5 then use the value of Field A */
If( match([Field A], '0', '3','4','5'), [Field A]) as [Compliant],
If you do need to use multiple if statements then try this:
IF([Field A]= '0', '0',
IF([Field A]= '3', '3',
IF([Field A]= '4', '4',
IF([Field A]= '5', '5', Null() )))) as [Compliant]