Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to build out a table that has either a calculated dimension or expression that will give me the number of working days (Business Days) in the proper month
For Example I am trying to complete the following table in QV
Year | Month | =(NetWorkingDays) |
2012 | Jan | |
2012 | Feb | |
2012 | Mar | |
2012 | Apr | |
2012 | May | |
2012 | Jun | |
2012 | Jul | |
2012 | Aug | |
2012 | Sep |
Any help would be aapreciated
Thanks
Tim
If you have a Date field connected to your Month and Year, you could use
=networkdays( min(Date), max(Date) )
edit:
I assume here that you got a value for each Date in the calendar. If not, try
=networkdays( monthstart(makedate(Year, Month)), monthend(makedate(Year, Month)) )
If you have a Date field connected to your Month and Year, you could use
=networkdays( min(Date), max(Date) )
edit:
I assume here that you got a value for each Date in the calendar. If not, try
=networkdays( monthstart(makedate(Year, Month)), monthend(makedate(Year, Month)) )