topic Re: Net Working Days Expression? in QlikView https://community.qlik.com/t5/QlikView/Net-Working-Days-Expression/m-p/371978#M491916 <HTML><HEAD></HEAD><BODY><P>That worked perfectly. Thank you!</P></BODY></HTML> Fri, 27 Jul 2012 15:34:53 GMT 2012-07-27T15:34:53Z Net Working Days Expression? https://community.qlik.com/t5/QlikView/Net-Working-Days-Expression/m-p/371976#M491914 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>Ineed an expression that does the following:</P><P></P><P>=(RevenueField/Number of working days in 2012 as of current day)*Total working days in 2012</P><P></P><P>Does anyone know how to do this? I tried Net Working Days, but couldn't quite get it. </P><P></P><P>Thanks!!</P></BODY></HTML> Fri, 27 Jul 2012 15:06:03 GMT https://community.qlik.com/t5/QlikView/Net-Working-Days-Expression/m-p/371976#M491914 2012-07-27T15:06:03Z Re: Net Working Days Expression? https://community.qlik.com/t5/QlikView/Net-Working-Days-Expression/m-p/371977#M491915 <HTML><HEAD></HEAD><BODY><P>Have you tried:</P><P></P><P><EM>=RevenueField / NetWorkDays(Yearstart(today()),today() ) *</EM></P><P><EM>NetWorkDays(Yearstart(today()),YearEnd(today()) )</EM></P><P></P><P>If you need to handle holidays, you can add a list of holidays as optional arguments to NetWorkDays().</P></BODY></HTML> Fri, 27 Jul 2012 15:23:50 GMT https://community.qlik.com/t5/QlikView/Net-Working-Days-Expression/m-p/371977#M491915 swuehl 2012-07-27T15:23:50Z Re: Net Working Days Expression? https://community.qlik.com/t5/QlikView/Net-Working-Days-Expression/m-p/371978#M491916 <HTML><HEAD></HEAD><BODY><P>That worked perfectly. Thank you!</P></BODY></HTML> Fri, 27 Jul 2012 15:34:53 GMT https://community.qlik.com/t5/QlikView/Net-Working-Days-Expression/m-p/371978#M491916 2012-07-27T15:34:53Z