OR Condition in SetExpression

[raju_salmon]

Hi,

I have gone through existing threads and understand that we can use + sign in set analysis to achieve OR condition. But however i am not how to write a expression for below sql query.

WHERE

[Type] IN ('PN','CT')

AND

(Store In ('DL A','RCS') OR [SType] != 'N Support')

Can anyone help me?

Regards,

Raju S

[tresesco · Accepted solution]

Try like:

Sum(

{<Type={'PN', 'CT'}>*(<Store={'DL A','RCS'}>+<SType-={'N Support'}>)}

Sales)