Calculation of amount between dates without using customer exit..

[Former Member]

My report need to calculate the total amount for the dates

User will provide a date and a number like 5,10.. difference to calculate the remaining dates.

i used formula to calculate the next two dates

ex- user entry(U) -: 20-03-14

      formula 1 (F1)-: U-5 = 15-03-14

      formula 2 (F2)-: U-10 = 10-03-14

DATA-

dates       amount

10-03-14: 100

11-03-14: 100

.

.

15-03-14: 100

.

.

20-03-14: 200

assume there is lost of data in b/w

i want to calculate that without using variable

[Loed]

Hi Praveen,

Sorry I did not understand well your query..

What should be the output of your report? Is it the 20-03-14: 200? Since the values of 15-03-14 and 10-03-14 are both 100?

The user entry will be:

DATE: 20-03-14

1st NUMBER: 5

2nd NUMBER: 10

OUTPUT:

Date               Amount

20-03-14          200

Am I right?

Regards,

Loed

[Former Member]

hi, if the customer enters 20-03-14 and 5, it should calculate the next date

ie.15-03-14 and the total transaction amount for that range of dates in column

amount (20-03-14 to 15-03-14)

200+..+...+100

[yasemin_kilinc]

Hi Praveen,

I don't think that it will be possible to do it without using a customer exit variable.I think it will be very simple to do it with a customer exit variable. You require two manual input variables; one for the date entry and one for the number. And you need a range variable with customer exit. In the exit read the value of these two manual input variables (I can help with that if you don't know how to), simple assign the customer exit variable high as the date and low as the ( date - num ).

Hope it gives an idea.

Regards

Yasemin...

[Former Member]

thanks for the info, i done it using variables long ago, but want to make sure is that the only way to achieve the output.

[Loed]

If only we can make the OFFSET thing as variable this can be done..But I think the only option here is to make the customer exit..

Regards,

Loed

[yasemin_kilinc]

I wish that were possible Loed

[Former Member]

thank you.. loed n yasemin

[Loed]

Welcome mate..

Regards,

Loed