Forum Discussion

Davykyndt's avatar
Davykyndt
Frequent Visitor
8 years ago
Solved

Creat column with shift numbers

I have a calendar table where I'd like to add a column with workingshifts. I have 2 working shifts working 7 days for shift A and then 7 days for shift B.   Any idea how I can calculate this basen ...
Need Help
  • Davykyndt's avatar
    Davykyndt
    8 years ago

    Hi I found a solution:

     

    Shiftnr = if((mod(calender[Date]+2;14)+1)<=7;"Shift A"; "Shift B")

     

     

parry2k's avatar
parry2k
Icon for Super User rankSuper User
8 years ago

Is there any relationship between SenShiftDay column and date column in your example?