7 Replies Latest reply: Apr 26, 2011 10:23 AM by Anne Duffy RSS

    if date within last 2 days of Month end

      Hi Guys

      Hope someone can help.

      I am calculating staff hours, on a normal working day we cout as 5.15 hours, and the last 2 days of the month we calculate as 7.15.

      I have the charts very simply

      Demension is [Date], and the Expression is: sum([hours])*5.15

      But is it possibly to put a condition that states if date is equal to either of the last 2 working days mulitply by 7.15 ?

      ( I cant figure it out as every month has different number of days etc!!)

      Thanks

      Anne