3 Replies Latest reply on May 7, 2013 10:42 AM by Shawn Wallwork

    How can I create a simple percentage calculation based on already created calculated fields?

    Ian Simpson



      I created a field to calculate the difference between 'ship date' and a 'promise to ship date as follows:


      datediff('day',[SO Promise Date],[Date Shipped])


      Then I created another calculated field to define these as GOOD, OK, or BAD as follows:


      If Avg([Shipment Delay (Days)])<1 then "GOOD" elseif

      Avg([Shipment Delay (Days)])<2 then "OK" else

      "BAD" end


      This all works fine, but now I would like to have a sheet that simply shows the percentage of on time shipments (GOOD field). I might also like to calculate all shipments, all on time shipments, and all late shipments.


      Can anyone help?