Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I have an expression..
Sum (if (IsPurchase = 1, Amount)
it works fine but i need to do it more...
the way it works is...
wherever IsPurchase = 1 it shows the Amount and shows 0 for others...
what i need is to show blank instead of 0 when conditions do not match.
I tried null() and text(null()) but it still is showing 0.
Can I achieve what I want?
Regards,
Saurabh
Sum (if (IsPurchase = 1, Amount,' ')
Nope, it does not work.
maybe if(IsPurchase = 1,sum(Amount),'') can work
maybe yes
It works...Thanks