Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have done my first simple QW report to measure Delivery Performance for my Suppliers. As a first attempt I did a simple if expression that compared confirmed date with Good receit date. This works fine and looks as follows:
If
((ConfirmedDate-GRdate) >0, 0, 1) as DP,Basically this will mean that all early deliveries will be measured as on time. I would now like to alter that expression so that it provides an On Time measure with no tolerance for early deliveries. My attempt was as follows:
If
((ConfirmedDate-GRdate) >0, 0, 1
I have obviously done something stupid... Could you give me advice on how to correct or maybe give me an alternative solution?
As an extension to this I would also like to add an expression that also take into account the quantity delivered. I would like to do it with an expression containing AND as follows:
Kind regards
Henrik
With no fault tolerence you can do something like this.
1: If ((ConfirmedDate-GRdate)=0, 1) as DP,
2: If ((ConfirmedDate-GRdate)=0 AND (GRquantity - OrderQuantity=0), 1) as DP,
... the AND expression I had in mind was:
AND(GRquantity=OrderQuantity)
Thanks
With no fault tolerence you can do something like this.
1: If ((ConfirmedDate-GRdate)=0, 1) as DP,
2: If ((ConfirmedDate-GRdate)=0 AND (GRquantity - OrderQuantity=0), 1) as DP,
Hello Michael,
Thank you. What if I wanted a tolerance, say +/- 1 day in the expression. Is there a function where I could use the absolute value, like in Excel: Abs(...)? Any other idea?
Thanks
Henrik
Hi
This will pass the deliveries in the tolerances defined by variables vDateTolerance and vQuantityTolerance:
If((Fabs(ConfirmedDate-GRdate) <= vDateTolerance)
And (Fabs(GRquantity - OrderQuantity) <= vQuantityTolerance), 1, 0) As DP
Regards
Jonathan