requirement

[Anonymous]

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

[zhadrakas]

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))

[Anonymous]

this is not working,is there any other syntax for set analysis for above expression?