topic please help with expression in QlikView

topic please help with expression in QlikView https://community.qlik.com/t5/QlikView/please-help-with-expression/m-p/1603409#M736413 <P>Hi All,</P><P>Please could you assist with this expression: the correct answer should be 2.47 wks but i keep getting 2.85 wks</P><P>If i activate the 'Sum of ROWS' function under 'Total Mode' in the expression tab - i get the correct answer.</P><P>However i do not want to 'overide' the function as i need the correct answer to reflect in the calculated text object as well</P><P><EM>Sum([Total Hours Taken (Leave)])/Avg([Hours - 4 Week Average])</EM></P><P>At a line level all the values are correct - but the sum values for 'Leave Taken - 4' and 'Leave Balances - 4' are incorrect </P><P> </P><TABLE><TBODY><TR><TD>Leave Accrued</TD><TD>Leave Taken - 4</TD><TD>Leave Balances - 4</TD></TR><TR><TD><STRONG>3.62 wks</STRONG></TD><TD><STRONG>2.85 wks</STRONG></TD><TD><STRONG>0.77 wks</STRONG></TD></TR><TR><TD>0.08 wks</TD><TD>0.00 wks</TD><TD>0.08 wks</TD></TR><TR><TD>0.15 wks</TD><TD>0.00 wks</TD><TD>0.15 wks</TD></TR><TR><TD>0.23 wks</TD><TD>0.00 wks</TD><TD>0.23 wks</TD></TR><TR><TD>0.31 wks</TD><TD>0.00 wks</TD><TD>0.31 wks</TD></TR><TR><TD>0.38 wks</TD><TD>0.00 wks</TD><TD>0.38 wks</TD></TR><TR><TD>0.46 wks</TD><TD>0.00 wks</TD><TD>0.46 wks</TD></TR><TR><TD>0.54 wks</TD><TD>0.00 wks</TD><TD>0.54 wks</TD></TR><TR><TD>0.62 wks</TD><TD>0.00 wks</TD><TD>0.62 wks</TD></TR><TR><TD>0.69 wks</TD><TD>0.00 wks</TD><TD>0.69 wks</TD></TR><TR><TD>0.77 wks</TD><TD>0.00 wks</TD><TD>0.77 wks</TD></TR><TR><TD>0.85 wks</TD><TD>0.00 wks</TD><TD>0.85 wks</TD></TR><TR><TD>0.92 wks</TD><TD>0.00 wks</TD><TD>0.92 wks</TD></TR><TR><TD>1.00 wks</TD><TD>0.00 wks</TD><TD>1.00 wks</TD></TR><TR><TD>1.08 wks</TD><TD>0.00 wks</TD><TD>1.08 wks</TD></TR><TR><TD>1.15 wks</TD><TD>0.00 wks</TD><TD>1.15 wks</TD></TR><TR><TD>1.23 wks</TD><TD>0.00 wks</TD><TD>1.23 wks</TD></TR><TR><TD>1.31 wks</TD><TD>0.00 wks</TD><TD>1.31 wks</TD></TR><TR><TD>1.38 wks</TD><TD>0.00 wks</TD><TD>1.38 wks</TD></TR><TR><TD>1.46 wks</TD><TD>0.00 wks</TD><TD>1.46 wks</TD></TR><TR><TD>1.54 wks</TD><TD>0.00 wks</TD><TD>1.54 wks</TD></TR><TR><TD>1.62 wks</TD><TD>0.17 wks</TD><TD>1.45 wks</TD></TR><TR><TD>1.69 wks</TD><TD>0.00 wks</TD><TD>1.53 wks</TD></TR><TR><TD>1.77 wks</TD><TD>0.15 wks</TD><TD>1.45 wks</TD></TR><TR><TD>1.85 wks</TD><TD>0.00 wks</TD><TD>1.52 wks</TD></TR><TR><TD>1.92 wks</TD><TD>0.00 wks</TD><TD>1.60 wks</TD></TR><TR><TD>2.00 wks</TD><TD>0.00 wks</TD><TD>1.68 wks</TD></TR><TR><TD>2.08 wks</TD><TD>0.00 wks</TD><TD>1.76 wks</TD></TR><TR><TD>2.15 wks</TD><TD>0.00 wks</TD><TD>1.83 wks</TD></TR><TR><TD>2.23 wks</TD><TD>0.00 wks</TD><TD>1.91 wks</TD></TR><TR><TD>2.31 wks</TD><TD>0.00 wks</TD><TD>1.99 wks</TD></TR><TR><TD>2.38 wks</TD><TD>0.00 wks</TD><TD>2.06 wks</TD></TR><TR><TD>2.46 wks</TD><TD>0.00 wks</TD><TD>2.14 wks</TD></TR><TR><TD>2.54 wks</TD><TD>0.00 wks</TD><TD>2.22 wks</TD></TR><TR><TD>2.62 wks</TD><TD>0.00 wks</TD><TD>2.29 wks</TD></TR><TR><TD>2.69 wks</TD><TD>0.09 wks</TD><TD>2.28 wks</TD></TR><TR><TD>2.77 wks</TD><TD>0.00 wks</TD><TD>2.36 wks</TD></TR><TR><TD>2.85 wks</TD><TD>0.12 wks</TD><TD>2.32 wks</TD></TR><TR><TD>2.92 wks</TD><TD>0.00 wks</TD><TD>2.40 wks</TD></TR><TR><TD>3.00 wks</TD><TD>0.00 wks</TD><TD>2.47 wks</TD></TR><TR><TD>3.08 wks</TD><TD>0.60 wks</TD><TD>1.95 wks</TD></TR><TR><TD>3.15 wks</TD><TD>0.11 wks</TD><TD>1.92 wks</TD></TR><TR><TD>3.23 wks</TD><TD>0.00 wks</TD><TD>1.99 wks</TD></TR><TR><TD>3.31 wks</TD><TD>0.00 wks</TD><TD>2.07 wks</TD></TR><TR><TD>3.38 wks</TD><TD>0.00 wks</TD><TD>2.15 wks</TD></TR><TR><TD>3.46 wks</TD><TD>0.17 wks</TD><TD>2.06 wks</TD></TR><TR><TD>3.54 wks</TD><TD>0.70 wks</TD><TD>1.43 wks</TD></TR><TR><TD>3.62 wks</TD><TD>0.36 wks</TD><TD>1.15 wks</TD></TR></TBODY></TABLE><P> </P> Wed, 25 Nov 2020 16:16:04 GMT MarioNZ 2020-11-25T16:16:04Z please help with expression https://community.qlik.com/t5/QlikView/please-help-with-expression/m-p/1603409#M736413 <P>Hi All,</P><P>Please could you assist with this expression: the correct answer should be 2.47 wks but i keep getting 2.85 wks</P><P>If i activate the 'Sum of ROWS' function under 'Total Mode' in the expression tab - i get the correct answer.</P><P>However i do not want to 'overide' the function as i need the correct answer to reflect in the calculated text object as well</P><P><EM>Sum([Total Hours Taken (Leave)])/Avg([Hours - 4 Week Average])</EM></P><P>At a line level all the values are correct - but the sum values for 'Leave Taken - 4' and 'Leave Balances - 4' are incorrect </P><P> </P><TABLE><TBODY><TR><TD>Leave Accrued</TD><TD>Leave Taken - 4</TD><TD>Leave Balances - 4</TD></TR><TR><TD><STRONG>3.62 wks</STRONG></TD><TD><STRONG>2.85 wks</STRONG></TD><TD><STRONG>0.77 wks</STRONG></TD></TR><TR><TD>0.08 wks</TD><TD>0.00 wks</TD><TD>0.08 wks</TD></TR><TR><TD>0.15 wks</TD><TD>0.00 wks</TD><TD>0.15 wks</TD></TR><TR><TD>0.23 wks</TD><TD>0.00 wks</TD><TD>0.23 wks</TD></TR><TR><TD>0.31 wks</TD><TD>0.00 wks</TD><TD>0.31 wks</TD></TR><TR><TD>0.38 wks</TD><TD>0.00 wks</TD><TD>0.38 wks</TD></TR><TR><TD>0.46 wks</TD><TD>0.00 wks</TD><TD>0.46 wks</TD></TR><TR><TD>0.54 wks</TD><TD>0.00 wks</TD><TD>0.54 wks</TD></TR><TR><TD>0.62 wks</TD><TD>0.00 wks</TD><TD>0.62 wks</TD></TR><TR><TD>0.69 wks</TD><TD>0.00 wks</TD><TD>0.69 wks</TD></TR><TR><TD>0.77 wks</TD><TD>0.00 wks</TD><TD>0.77 wks</TD></TR><TR><TD>0.85 wks</TD><TD>0.00 wks</TD><TD>0.85 wks</TD></TR><TR><TD>0.92 wks</TD><TD>0.00 wks</TD><TD>0.92 wks</TD></TR><TR><TD>1.00 wks</TD><TD>0.00 wks</TD><TD>1.00 wks</TD></TR><TR><TD>1.08 wks</TD><TD>0.00 wks</TD><TD>1.08 wks</TD></TR><TR><TD>1.15 wks</TD><TD>0.00 wks</TD><TD>1.15 wks</TD></TR><TR><TD>1.23 wks</TD><TD>0.00 wks</TD><TD>1.23 wks</TD></TR><TR><TD>1.31 wks</TD><TD>0.00 wks</TD><TD>1.31 wks</TD></TR><TR><TD>1.38 wks</TD><TD>0.00 wks</TD><TD>1.38 wks</TD></TR><TR><TD>1.46 wks</TD><TD>0.00 wks</TD><TD>1.46 wks</TD></TR><TR><TD>1.54 wks</TD><TD>0.00 wks</TD><TD>1.54 wks</TD></TR><TR><TD>1.62 wks</TD><TD>0.17 wks</TD><TD>1.45 wks</TD></TR><TR><TD>1.69 wks</TD><TD>0.00 wks</TD><TD>1.53 wks</TD></TR><TR><TD>1.77 wks</TD><TD>0.15 wks</TD><TD>1.45 wks</TD></TR><TR><TD>1.85 wks</TD><TD>0.00 wks</TD><TD>1.52 wks</TD></TR><TR><TD>1.92 wks</TD><TD>0.00 wks</TD><TD>1.60 wks</TD></TR><TR><TD>2.00 wks</TD><TD>0.00 wks</TD><TD>1.68 wks</TD></TR><TR><TD>2.08 wks</TD><TD>0.00 wks</TD><TD>1.76 wks</TD></TR><TR><TD>2.15 wks</TD><TD>0.00 wks</TD><TD>1.83 wks</TD></TR><TR><TD>2.23 wks</TD><TD>0.00 wks</TD><TD>1.91 wks</TD></TR><TR><TD>2.31 wks</TD><TD>0.00 wks</TD><TD>1.99 wks</TD></TR><TR><TD>2.38 wks</TD><TD>0.00 wks</TD><TD>2.06 wks</TD></TR><TR><TD>2.46 wks</TD><TD>0.00 wks</TD><TD>2.14 wks</TD></TR><TR><TD>2.54 wks</TD><TD>0.00 wks</TD><TD>2.22 wks</TD></TR><TR><TD>2.62 wks</TD><TD>0.00 wks</TD><TD>2.29 wks</TD></TR><TR><TD>2.69 wks</TD><TD>0.09 wks</TD><TD>2.28 wks</TD></TR><TR><TD>2.77 wks</TD><TD>0.00 wks</TD><TD>2.36 wks</TD></TR><TR><TD>2.85 wks</TD><TD>0.12 wks</TD><TD>2.32 wks</TD></TR><TR><TD>2.92 wks</TD><TD>0.00 wks</TD><TD>2.40 wks</TD></TR><TR><TD>3.00 wks</TD><TD>0.00 wks</TD><TD>2.47 wks</TD></TR><TR><TD>3.08 wks</TD><TD>0.60 wks</TD><TD>1.95 wks</TD></TR><TR><TD>3.15 wks</TD><TD>0.11 wks</TD><TD>1.92 wks</TD></TR><TR><TD>3.23 wks</TD><TD>0.00 wks</TD><TD>1.99 wks</TD></TR><TR><TD>3.31 wks</TD><TD>0.00 wks</TD><TD>2.07 wks</TD></TR><TR><TD>3.38 wks</TD><TD>0.00 wks</TD><TD>2.15 wks</TD></TR><TR><TD>3.46 wks</TD><TD>0.17 wks</TD><TD>2.06 wks</TD></TR><TR><TD>3.54 wks</TD><TD>0.70 wks</TD><TD>1.43 wks</TD></TR><TR><TD>3.62 wks</TD><TD>0.36 wks</TD><TD>1.15 wks</TD></TR></TBODY></TABLE><P> </P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/please-help-with-expression/m-p/1603409#M736413 MarioNZ 2020-11-25T16:16:04Z Re: please help with expression https://community.qlik.com/t5/QlikView/please-help-with-expression/m-p/1603412#M736414 <P>Fixed in script - thanks!!</P> Thu, 18 Jul 2019 00:22:42 GMT https://community.qlik.com/t5/QlikView/please-help-with-expression/m-p/1603412#M736414 MarioNZ 2019-07-18T00:22:42Z