Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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))
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.
then u'll have to change the measures of all of ur buckets the same way as previously shown