3 Replies Latest reply on Jan 4, 2016 1:19 PM by Ryan Rogers

    Case Month(date) to set # of working days in a month not working.

    matt.kaskow

      I am trying to create a calculation that sets the number of days in a month to = a certain number i.e., the number of specific working days in that month. Basically, if the month is January then the # of days needs to = 19, February then 20 days, March then 22 days, etc.

       

      I have created a calculation (see screenshot below) that shows I am using the case month(date) to set the number of days for each month. The problem is I am getting get numbers of days in that month that each employee worked instead of the number I set.

       

      Based on my calculation every number in January should appear to be 19, but I am getting 15 for the first example, 21 for the second, and then two blanks. Any thoughts? Thank you!

       

       

      Ex1.png