Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Ramya
I have also just tested the if() variant and that works as well.
Best Regards, Bill