Ineed an expression that does the following:
=(RevenueField/Number of working days in 2012 as of current day)*Total working days in 2012
Does anyone know how to do this? I tried Net Working Days, but couldn't quite get it.
Have you tried:
=RevenueField / NetWorkDays(Yearstart(today()),today() ) *
If you need to handle holidays, you can add a list of holidays as optional arguments to NetWorkDays().
That worked perfectly. Thank you!
Retrieving data ...