Return 0 when there is clearing date (Invoices report)

[krithikarees]

Hello All,

I have a table where I am trying to get null values when there is a clearing date and not bucket it. As net due date is the day an invoice was opened and if a clearing date exists it should return null values. Any suggestions?

[OmarBenSalem]

basically if there a clearing date, the net due should be null()?

maybe change ur net due measure to:

if(len(trim(clearing))>0,null(),sum(NetDue))

[krithikarees]

No - If I have a clearing date . I do not want any amounts to reflect in the buckets I have  and If there is no clearing date - I want it to show in the bucket.

[OmarBenSalem]

then u'll have to change the measures of all of ur buckets the same way as previously shown