0

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

*Edited
by jovillanuev*: n/a