Set analysis

[tizianacaem]

Hi all,

I'd like to convert this expression with the set analysis syntax,

sum ( if (FIELD1<>'S' OR FIELD2='L', (FIELD3 - FIELD4), FIELD5))

Any suggestions please?

Thanks

Tiziana

[#2]

I remember reading somewhere that set analysis always uses "and" logic so I'm not sure whether this is possible. I could be wrong though!

I don't see what's wrong with if(field1 <> 'S' or field2 = 'L', field3 - field4, field5) no need to use sum here.

[#3]

Hi,

Easier way to write your condition is-

IF(Field1<>'S' OR Field2='L', Sum(Field3-Field4),Field5)

With SET Analysis, you cannot have "OR"; its "AND".

Happy Thoughts