Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all:
I have an Accounts Receivable (A/R) report below:
1. Dimensions as shown in the first 5 columns.
2. (Measure) Open AR $ = Work Billed $ - Cash Received $.
3. A Date field (not shown), which contains the 'Work Billed' date.
4. The same Date field (also not shown) which contains the 'Cash Received' date.
When I do not include the Date field, I get the correct report below.
But, I need to add the 'Due Date' which is equal to the 'Work Billed Date' + 'Customer Payment Terms Date'. When I add this date, I get the report shown in the second screen shot.
I need to remove the null value date rows from the the second report. I have tried several If and Set approaches to no avail and could use some feedback from the Community.
Thanks,
Edward
May be this:
If([Open AR] > 0, YourDueDateExpressionHere)
Sorry, I don't understand your setting.
It's not totally clear what your dimensions and expressions are, also some fields suddenly pop in your description like 'Customer Payment Terms Date' without being introduced.
How these fields are related to each other is totall unclear.
In general, use aggregation functions in your expressions, I assume your measure is missing that:
If this doesn't help, please post a more complete description of your setting, e.g. by posting a small sample QVW.
Regards,
Stefan