Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
field1='value' and (field2='NA' or isnull(field3)) and field4<>'NA' and (field5<>'null' or field6<>'null')
how to cnvert this to set analysis expression
dont know how to write or Operator in set Analysis. But you mix if and set analysis
=sum({<field1={'value'}, field4<>{'NA'}>}if((field5<>'null' or field6<>'null') AND (field2='NA' or isnull(field3)), YOUR_FIELD))
this is not working,is there any other syntax for set analysis for above expression?