Convert NULL to 0

[stabben23]

Hi,

I have no sales for an Item in a month, sum(amount) and try to compare it with a Budget in a straight table. The Budget has a value but wont show up in my table because sales in NULL. The Budget is concatenated into the sales. How to solve this in an easy way?

[kaushiknsolanki]

Hi,

     There are ways, but this depends on how you are linking the budget with your data.

     It will be helpful if you post some sample example.

Regards,

Kaushik Solanki