I am trying to calculate the current workdays in month, holidays need to be omitted as well. In july, the current total is 20 days.
For some reason my formula is giving me 23 days. Any help for finding this answer please?
vDay_in_M = NetWorkDays(MonthStart(Max(Date)), MonthEnd(Max(Date)), $(vHolidays))
vDays_Con =
Count({$<Status_Dash={'Completed'}, Month = {"$(=Month(FirstWorkDate(ConvertToLocalTime(Date(now()), 'GMT-05:00'),1,$(vHolidays))))"},
Year = {"$(=Year(FirstWorkDate(ConvertToLocalTime(Date(now()), 'GMT-05:00'),1,$(vHolidays))))"}>}
distinct Date_Dash) -1
Equation for formula is:
=Sum(aggr(
((Sum({$<Status_Dash={'Completed'}, Month = {"$(=Month(FirstWorkDate(ConvertToLocalTime(Date(now()), 'GMT-05:00'),1,$(vHolidays))))"},
Year = {"$(=Year(FirstWorkDate(ConvertToLocalTime(Date(now()), 'GMT-05:00'),1,$(vHolidays))))"}>} (Ave_Cost_Dash * Processed_Dash)))/(sum(vDays_Con))) * (Sum(vDay_in_M))
,Date_Dash, Program_Dash, Status_Dash))