cancel
Showing results for 
Search instead for 
Did you mean: 

Calculation of amount between dates without using customer exit..

Former Member
0 Kudos
49

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Loed
Active Contributor
0 Kudos

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
0 Kudos

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
Active Contributor
0 Kudos

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
0 Kudos

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
Active Contributor
0 Kudos

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
Active Contributor
0 Kudos

I wish that were possible Loed

Former Member
0 Kudos

thank you.. loed n yasemin

Loed
Active Contributor
0 Kudos

Welcome mate..

Regards,

Loed