16 Replies Latest reply: Jul 1, 2015 8:50 AM by Ruben Marin RSS

    Issue in calculating Turn for multiple dates

    Sindhu Neelisetty

      Hi Friends,

       

      I've an issue in calculating the turn for two fields.

       

      Lets say I have a field Date1, Date2 where the turn should be calucated for Date1 and Date2

       

      Sample Data

        

      Order NoIterationStartEndTurn
      123Iteration123/06/2015 15:42:4624/06/2015 09:11:33

      =networkdays(23/06/2015,24/06/2015)

      =2

      123Iteration 224/06/2015 09:18:2324/06/2015 18:29:17

      --Turn 2

      =1

      123Iteratin 326/06/2015 11:28:0826/06/2015 14:08:18

      --Turn 3

      =1

      123Iteration 426/06/2015 14:36:1226/06/2015 16:35:54

      --Turn 4

      =1

      Average=Average(2,1,1,1)=1.25

       

      But the Start Date and End Date comes from different tables based on Primary Key and iteration is what I added for better understanding of my requirement.

       

      Now i want to calculate the turn at every iteration based on the Order No.

       

      If I try to join these two fields with the Order No, it is doing cross join and populating 16 combinations and the turn metric is being calculated wrongly.

       

      Wanted help on how to deal with such scenarios.

       

      Final I want to see turn as 1.25 for the Order 123

       

      Thanks,

      Sindhu