-1

I am trying to create a finance report based on date range parameters selected. There are 35 hours available each week. If a person selects 2 weeks in the date parameters we want to calculate 35*2 as total hours available.

Is there a calculation that will help with this?

aduguid
  • 3,099
  • 6
  • 18
  • 37
Erin
  • 9
  • 5

1 Answers1

0

I would store the value 7 as a hidden parameter HoursPerWorkDay and then do the calculation based on work days between your 2 date parameters.

=((DateDiff(DateInterval.day, Parameters!StartDate.Value, Parameters!EndDate.Value) + 1) 
- DateDiff(DateInterval.WeekOfYear, Parameters!StartDate.Value, Parameters!EndDate.Value)*2) 
* Parameters!HoursPerWorkDay.Value

enter image description here

aduguid
  • 3,099
  • 6
  • 18
  • 37
  • 1
    If my answer solved your issue, can you click on the check mark beside the answer to toggle it from greyed out to filled in? – aduguid May 19 '18 at 05:31