1 Reply Latest reply on Oct 13, 2018 1:19 AM by Yuriy Fal

    Date calculation similar to SQL partition over

    Dušan M

      Hi all,

       

      I need help in creating some calculation for cost reduction. Let say we have service and we are receiving dispatch requests. There are different locations within the city and some of them have priority (single) while others are normal (multi). For normal locations, we want to have a wait time of 60 min while for others dispatch is immediate.

      I want to calculate saving possibility (last column in the attached file) and the rule should be:

      • If  there is a dispatch for the priority customer (single column in the Excel) result is 0
      • if within the single city there is dispatch for the normal customer (multi) and within next 60 min there is another  dispatch from priority customer in the same city then that is saving option and result is 1

       

      Is there an option to do this and how?