https://community.qlik.com/t5/App-Development/Calculation-of-Utilization/m-p/1546113#M39332 <P>Hi Friends,</P><P>Good Morning,</P><P>Below is the attached Excel data file I am currently&nbsp;working on and I want to calculate utilization% with respect to no of working days in a month which is mentioned in workdays field and I want to exclude weekends while calculating it and if the location is 'Gurgaon' we have take daily working hours as 8.5 or else 9.0. Please help me with some suggestions ASAP.</P><P>Thanks &amp; Regards,</P><P>Vinod</P><P>&nbsp;</P> Tue, 19 Feb 2019 04:34:40 GMT vinod1992 2019-02-19T04:34:40Z https://community.qlik.com/t5/App-Development/Calculation-of-Utilization/m-p/1546113#M39332 <P>Hi Friends,</P><P>Good Morning,</P><P>Below is the attached Excel data file I am currently&nbsp;working on and I want to calculate utilization% with respect to no of working days in a month which is mentioned in workdays field and I want to exclude weekends while calculating it and if the location is 'Gurgaon' we have take daily working hours as 8.5 or else 9.0. Please help me with some suggestions ASAP.</P><P>Thanks &amp; Regards,</P><P>Vinod</P><P>&nbsp;</P> Tue, 19 Feb 2019 04:34:40 GMT https://community.qlik.com/t5/App-Development/Calculation-of-Utilization/m-p/1546113#M39332 vinod1992 2019-02-19T04:34:40Z