Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Question from harshitpandey on Feb 17 at 8:55 AM Dear Experts I have a scenario in which we are getting data as stated below under INPUT and we want to report it based on Selection of Date field on selection screen and report according to the Date range provided at input as shown in OUTPUT INPUT : TRAN_ID Char Date Quantity 1 AA 01.02.2014 1000 2 BB 01.02.2014 2000 3 AA 02.02.2014 1500 4 CC 03.02.2014 1230 5 BB 03.02.2014 1100 6 CC 04.02.2014 1900 7 AA 04.02.2014 2500 8 DD 05.02.2014 1950 9 CC 05.02.2014 1800 10 DD 06.02.2014 1600 SELECTION DATE 01.02.2014 TO 05.02.2014 OUTPUT: Char Date Quantity MAX Diff MIN Diff AA 01.02.2014 1000 1500 0 AA 02.02.2014 1500 1000 500 AA 04.02.2014 2500 0 1500 BB 01.02.2014 2000 0 900 BB 03.02.2014 1100 900 0 CC 03.02.2014 1230 670 0 CC 04.02.2014 1900 0 670 CC 05.02.2014 1800 100 570 DD 05.02.2014 1950 0 0 | Reply to this email to post your response. __.____._ | _.____.__ |