How to add condition SOURCE='TDSS' into sum(if(L5M='-1',sales/1000))

[paulyeo11]

Hi All

My expression below is working fine :-

sum(if(L5M='-1',sales/1000))

I like to add condition below into above expression :-

SOURCE='TDSS'

sum(if(L5M='-1' & SOURCE='TDSS',sales/1000))

I try the above , it return null value.

Hope some one can help me.

Paul

[paulyeo11]

my qvw

[effinty2112 · Accepted solution]

Hi Paul,

               Try:

=sum({$<L5M = {'-1'}, SOURCE = {'TDSS'}>}sales)/1000

Kind regards

Andrew

[paulyeo11]

Hi Andres

Thank you very much.

Paul