4 Replies Latest reply on Nov 1, 2018 4:28 PM by Mei Ziegler

    Formula question for ontime rule

    Mei Ziegler

      Hello,

       

      I am trying to create a formula that states

      if customer is in group 1 please use this formula for ontime delivery, if customer is on group 2 then use this formula for ontime,etc

       

      The formulas that shows they are ontime if the delivery date falls within the formula range:

       

      On delivery date through minus 4 calendar days

      -4 days from delivery date till +2 Business days

      On Delivery date through minus 3 business days

      +/- 5 days from delivery da

       

      Any help will be much appreciated.

       

      Thanks,

      Mei