Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Paul,
Try:
=sum({$<L5M = {'-1'}, SOURCE = {'TDSS'}>}sales)/1000
Kind regards
Andrew
my qvw
Hi Paul,
Try:
=sum({$<L5M = {'-1'}, SOURCE = {'TDSS'}>}sales)/1000
Kind regards
Andrew
Hi Andres
Thank you very much.
Paul