Skip to Content
0
Former Member
Jun 03, 2008 at 12:53 PM

Count of Po delivered on time

25 Views

Hi All,

I am having a problem regarding my result row when am trying to obtain my result as per PO Document number.

In my query :

Po Num Po line Item Gr_date_entry Po_Requested _date (GRdate-POdate) Ontime/late

1000 10 15/5/08 16/05/08 -1 1

10 20/5/08 17/05/08 3 0

20 30/5/08 0 0

Result 1

The field "Ontime/late" gives indication whether the goods were recieved on time ( value 1) or late ( value 0) per schedule line. Note that Ontime/late is a virtual key figure that is being filled by 1 or 0 after comparing the two dates. My requirement is to display the number of PO that is ontime or late and not as per the schedule line. Can you please help us.Points will be assigned.

Thks