Hi Guys,
Kindly please help me on how to this in scripts.
How to calculate and get the average aging based on the Aging period.
I could not figure out on how to do this in script.
btw, even the format is not like my sample it's okay, unless i got the correct result.
Here is my sample data.
MyTable
Total_aging_days
---------0-10 days
6
8
---------11-30 days
15
25
---------31-60 days
40
55
---------61-150 days
65
120
150
Sample Result|
0-10 days|11-30 days|31-60 days|61-150 days --Aging period
-------------------------------------------
7|20|47.5|111.66 --avg result from mytable
Thank you in Advance.
Jonel