Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
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.
Thanks!!
Have you tried:
=RevenueField / NetWorkDays(Yearstart(today()),today() ) *
NetWorkDays(Yearstart(today()),YearEnd(today()) )
If you need to handle holidays, you can add a list of holidays as optional arguments to NetWorkDays().
Have you tried:
=RevenueField / NetWorkDays(Yearstart(today()),today() ) *
NetWorkDays(Yearstart(today()),YearEnd(today()) )
If you need to handle holidays, you can add a list of holidays as optional arguments to NetWorkDays().
That worked perfectly. Thank you!