I created a report to multiply hours in a day and the number of days in the month to result in the total hours in the month. However, when carrying out the calculation, it only adds the days in which the analyst indicated hours in a task and not the days on the calendar. I verified that the data source that brings this data is Utilization and Performance, as it can obtain the calendar data.
In the report, I would like to show how many hours are expected for the month of November. For example, November will have 20 working days. Each day, each analyst must work 7 hours. Each analyst must have 7 hours a day * 20 days = 140 hours of work available in the month of November. Is there a way to make this calculation leaving the 140 hours the same for all analysts?
Thank you very much in advance!