Split set of Dates based on the input value

[Anonymous]

Hi,

My scenario is

In my table I have two fields Date and Amount.

I need to split the set of dates based on the given input.

Like,

If I gave input as 10, then it should split dates in 10. From 01-09-2012 to 10-09-2012, 11 to 20 and so on and the sum of amount to be calculated for the date frame.

For Example,

Date                               Amount

01-09-2012                          10

02-09-2012                          10   

03-09-2012                          10

04-09-2012                          20

05-09-2012                          20   

06-09-2012                          20

Input value = 3

output:

DateFrame                            Amount

01-09-2012 - 03-09-2012          30

04-09-2012 - 06-09-2012          60

Thanks in Advance.

Regards,

Leni

[Anonymous]

Any help??

[Anonymous · Accepted solution]

Using Class function we can achieve this.

Sample is attached