mattyblueice
Board Regular
- Joined
- Jul 24, 2014
- Messages
- 85
- Office Version
- 365
- Platform
- MacOS
Good Morning I have a challenge with an array that I am working on - I searched through the forums and my solution should work but its not.
I am working to create a report that has a data validation list of Companies and when the user selects a company from the drop down all of the employees working on that company will populate. The data source has Company, Employees, Month and the Hours worked by that employee in that month. Here is a layout of what the data source looks like, the report setup and the formula I am using (I am doing Cntrl, Shift, Enter for the Array). I am getting all blanks and I am not sure what is the issue. Any ideas? Thanks so much
I am working to create a report that has a data validation list of Companies and when the user selects a company from the drop down all of the employees working on that company will populate. The data source has Company, Employees, Month and the Hours worked by that employee in that month. Here is a layout of what the data source looks like, the report setup and the formula I am using (I am doing Cntrl, Shift, Enter for the Array). I am getting all blanks and I am not sure what is the issue. Any ideas? Thanks so much
Last edited: