Forum Discussion
Selwynster
4 years agoHelper II
Ageing Debtor Count
Hi all I am trying to count the number of distinct debtors who have an invoice date > 12 months ago, from today. This needs to be rolling figure on a bar chart Source data could look something l...
Ashish_Mathur
4 years agoSuper User
You are welcome. Share some data and clearly show the xpected result on the data that you share.
Selwynster
4 years agoHelper II
https://1drv.ms/u/s!AhNtTaweU4MzmDzD6JFUAXy0sqfk?e=cXfzOy
Please see above link. I should be getting 1076 (as seen by total on the right table) for July on the left graph;
And 691 for June.
- Ashish_Mathur4 years agoSuper User
That is a dead link.