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