Hey guys,
I feel like I'm overthinking this one. I am just trying to grab data from June-December for this year. This is how I am attempting this, just tells me it contains only undefined values.
=(Sum({$<Status_Dash={'Completed'}, Month = {"$(=Year(FirstWorkDate(ConvertToLocalTime(Date(now()), 'GMT-05:00'),1,$(vHolidays))))"},
MonthNum = {6, 7, 8, 9, 10, 11, 12},
Year = {"$(=Year(FirstWorkDate(ConvertToLocalTime(Date(now()), 'GMT-05:00'),1,$(vHolidays))))"}>}
(Ave_Cost_Dash * Processed_Dash)))
/
(Sum({$<Status_Dash={'Completed'}, Month = {"$(=Year(FirstWorkDate(ConvertToLocalTime(Date(now()), 'GMT-05:00'),1,$(vHolidays))))"},
MonthNum = {6, 7, 8, 9, 10, 11, 12},
Year = {"$(=Year(FirstWorkDate(ConvertToLocalTime(Date(now()), 'GMT-05:00'),1,$(vHolidays))))"}>}
Emp_Act_Dash))
But if I do not include Month, or MonthNum, it works but collects different data. There is more Processed_Dash data then Emp_Act_Dash. I just want to have the same amount of data.