2 Replies Latest reply: Sep 26, 2012 2:25 AM by selindellh RSS

    Using if expression to create field On Time delivery

      Hi,

      I am building my first QW document so bear with me if I am a bit slow! I am trying to build a report to measure my suppliers Delivery Performance. For this I am comparing the Confirmed Delivery Date with the actual Delivery date as follows:

       

      (ConfirmedDate-GRdate) as GRdelta

       

      GRdelta gives a difference in days. Just to make it simple I would like to start with only measuring late deliveries and have been trying to create a field DP using the following if-expression:

       

       

      If

      (GRdelta>0, 0, 100) as DP               

       

      This did not work however...

       

      I want the field DP so that I can calculate the average Delivery Performance.

       

      What is wrong with the expression? Can someone offer an alternative solution?

       

      Thanks

       

      Henrik