Filling missing value with number 0

[#1]

Hi guys,

I m creating a report where there are many missing values...for instance...

if you look at first line then there is a missing value for cust4 because there is no row for account "Advertising and Promotion" for cust4.

My requirement is to fill these cells with number 0.

I tried "Populate missing cells" but it has two problems...first it perhaps does not enter a number 0 and second it fills all other misisng cells in different columns also with 0 which is not desirable...

Is there any other way to accomplish my task?

Regards,

Saurabh

[#2]

Thanks Bill,

I see it is working....may be something else wrong with my expression...i am trying with it...and will update you guys once i am done.

[Anonymous]

Ramya

I have also just tested the if() variant and that works as well.

Best Regards,     Bill