Set analysis help

[alan_grn]

I am trying to do the following. COuld you please help with the set analysis.

IF FIELD1 value <> 'text value' then sum fieldvaue2 where fieldvlaue3 <> 'a value'

[#2 · Accepted solution]

HI,

Try this:

If(Field1 <> 'text value', sum({$<Field3 -= {'a value'}>} Field2))

Regards

[Miguel_Angel_Baeyens]

Hello,

Just going one step further, I'd include all conditional in set analysis. It shuould work and perform better

sum({$< Field1 -= {'text value'}, Field3 -= {'a value'} >} Field2)

Regards.