Forum Discussion
Controller123
3 years agoFrequent Visitor
Dynamic AR Aging Not working on Customer Level
Hello, I am trying to build a series of measures for a report that will dynamically calculate the AR aging by buckets (current, <15 days overdue, 16-30 days overdue, 31-90 days overdue, 90+ overd...
Controller123
3 years agoFrequent Visitor
Hey Anonymous . Thanks for the proposed solution. I shifted this Invoice Aging metric to a table named Invoice Aging. The table looks like this:
When I pasted your formula into a new measure in this table, i get the following errors:
1)
2)
How can i fix these errors?
For reference, here is the sales measure that is causing the issue, which sums up the amount for every transaction type but 15 (which is payments)
Controller123
3 years agoFrequent Visitor
Anonymous Do you have an update on my question?