Average per Day in load

[#1]

Hi, everybody.

I have a following table:

Date Computer Calculations

2009/04/25 A 40

2009/04/25 B 10

2009/04/28 A 70

2009/04/29 B 90

and I need to build a resident table from this one in Load script

with this derivative data:

Date Computer AvgCalculationsPerDay

2009/04/25 A 10

2009/04/26 A 10

2009/04/27 A 10

2009/04/28 A 10

2009/04/25 B 30

2009/04/26 B 30

2009/04/27 B 30

2009/04/28 B 30

2009/04/29 B 30

Help please

[disqr_rm]

Hi,

The example of your data and the scenario do not make sense. Could you please elaborate little more?

[#3]

Some explanation about the means of column Calculations:

The example with Computer A: On 2009/04/25 the value of calculations column is 40, there are some accumulations on 26,27 and the value in Calculations column is increased with 30 and the new value is 70 on 2009/04/28.

It's the same situation with computer B.

I need to calculate the average value per each day from 2009/04/25 to 2009/04/29 for each one computer (computer A and computer B)

[#4 · Accepted solution]

Hi,

I`m not sure, whether i have understood your problem correctcly r not.

if my understanding was correct, attached application would help you to fill the missing rows.

If this helps you, all credits goes to Mr. Rob Since i had taken this application from his cookbook.

Good Luck

Regards

Sridhar