One expression question

[#1]

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

[rustyfishbones]

Sum (if (IsPurchase = 1,  Amount,' ')

[#3]

Nope, it does not work.

[Clever_Anjos]

maybe if(IsPurchase = 1,sum(Amount),'') can work

[rustyfishbones]

maybe yes

[#6]

It works...Thanks