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

    Formula question for ontime rule

    Mei Ziegler



      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.