topic Rounding problem in QlikView https://community.qlik.com/t5/QlikView/Rounding-problem/m-p/470355#M697137 <HTML><HEAD></HEAD><BODY><P>Hi to all,</P><P></P><P>I have the following data:</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="256"><TBODY><TR><TD height="19" width="64">group1</TD><TD width="64">group2</TD><TD width="64">group3</TD><TD width="64">val</TD></TR><TR><TD height="19">A1</TD><TD>B2</TD><TD>X</TD><TD align="right">15,3451</TD></TR><TR><TD height="19">A1</TD><TD>B2</TD><TD>Y</TD><TD align="right">20,4511</TD></TR><TR><TD height="19">A1</TD><TD>B2</TD><TD>Z</TD><TD align="right">41,3983</TD></TR><TR><TD height="19">A1</TD><TD>B2</TD><TD>W</TD><TD align="right">22,8055</TD></TR><TR><TD height="19">A1</TD><TD>B3</TD><TD>X</TD><TD align="right">22,8756</TD></TR><TR><TD height="19">A1</TD><TD>B3</TD><TD>Y</TD><TD align="right">41,7893</TD></TR><TR><TD height="19">A1</TD><TD>B3</TD><TD>Z</TD><TD align="right">13,8733</TD></TR><TR><TD height="19">A1</TD><TD>B3</TD><TD>W</TD><TD align="right">21,4618</TD></TR></TBODY></TABLE><P></P><P>The sum of A1-B2 where group3 = X,Y,Z, W is 100 and the same for A2-B2.</P><P></P><P>I need to get the field val as an integer and still have the total to 100.</P><P></P><P>the result can be something like:</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="320"><TBODY><TR><TD height="19" width="64">group1</TD><TD width="64">group2</TD><TD width="64">group3</TD><TD width="64">val</TD><TD width="64"><BR /></TD></TR><TR><TD height="19">A1</TD><TD>B2</TD><TD>X</TD><TD align="right">15,3451</TD><TD align="right">15</TD></TR><TR><TD height="19">A1</TD><TD>B2</TD><TD>Y</TD><TD align="right">20,4511</TD><TD align="right">21</TD></TR><TR><TD height="19">A1</TD><TD>B2</TD><TD>Z</TD><TD align="right">41,3983</TD><TD align="right">41</TD></TR><TR><TD height="19">A1</TD><TD>B2</TD><TD>W</TD><TD align="right">22,8055</TD><TD align="right">23</TD></TR><TR><TD height="19"><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD></TR><TR><TD height="19">A1</TD><TD>B3</TD><TD>X</TD><TD align="right">22,8756</TD><TD align="right">23</TD></TR><TR><TD height="19">A1</TD><TD>B3</TD><TD>Y</TD><TD align="right">41,7893</TD><TD align="right">42</TD></TR><TR><TD height="19">A1</TD><TD>B3</TD><TD>Z</TD><TD align="right">13,8733</TD><TD align="right">14</TD></TR><TR><TD height="19">A1</TD><TD>B3</TD><TD>W</TD><TD align="right">21,4618</TD><TD align="right">21</TD></TR></TBODY></TABLE><P></P><P>Any idea to reach that?</P><P></P><P>Thanks!</P></BODY></HTML> Fri, 22 Mar 2013 16:20:08 GMT 2013-03-22T16:20:08Z Rounding problem https://community.qlik.com/t5/QlikView/Rounding-problem/m-p/470355#M697137 <HTML><HEAD></HEAD><BODY><P>Hi to all,</P><P></P><P>I have the following data:</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="256"><TBODY><TR><TD height="19" width="64">group1</TD><TD width="64">group2</TD><TD width="64">group3</TD><TD width="64">val</TD></TR><TR><TD height="19">A1</TD><TD>B2</TD><TD>X</TD><TD align="right">15,3451</TD></TR><TR><TD height="19">A1</TD><TD>B2</TD><TD>Y</TD><TD align="right">20,4511</TD></TR><TR><TD height="19">A1</TD><TD>B2</TD><TD>Z</TD><TD align="right">41,3983</TD></TR><TR><TD height="19">A1</TD><TD>B2</TD><TD>W</TD><TD align="right">22,8055</TD></TR><TR><TD height="19">A1</TD><TD>B3</TD><TD>X</TD><TD align="right">22,8756</TD></TR><TR><TD height="19">A1</TD><TD>B3</TD><TD>Y</TD><TD align="right">41,7893</TD></TR><TR><TD height="19">A1</TD><TD>B3</TD><TD>Z</TD><TD align="right">13,8733</TD></TR><TR><TD height="19">A1</TD><TD>B3</TD><TD>W</TD><TD align="right">21,4618</TD></TR></TBODY></TABLE><P></P><P>The sum of A1-B2 where group3 = X,Y,Z, W is 100 and the same for A2-B2.</P><P></P><P>I need to get the field val as an integer and still have the total to 100.</P><P></P><P>the result can be something like:</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="320"><TBODY><TR><TD height="19" width="64">group1</TD><TD width="64">group2</TD><TD width="64">group3</TD><TD width="64">val</TD><TD width="64"><BR /></TD></TR><TR><TD height="19">A1</TD><TD>B2</TD><TD>X</TD><TD align="right">15,3451</TD><TD align="right">15</TD></TR><TR><TD height="19">A1</TD><TD>B2</TD><TD>Y</TD><TD align="right">20,4511</TD><TD align="right">21</TD></TR><TR><TD height="19">A1</TD><TD>B2</TD><TD>Z</TD><TD align="right">41,3983</TD><TD align="right">41</TD></TR><TR><TD height="19">A1</TD><TD>B2</TD><TD>W</TD><TD align="right">22,8055</TD><TD align="right">23</TD></TR><TR><TD height="19"><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD></TR><TR><TD height="19">A1</TD><TD>B3</TD><TD>X</TD><TD align="right">22,8756</TD><TD align="right">23</TD></TR><TR><TD height="19">A1</TD><TD>B3</TD><TD>Y</TD><TD align="right">41,7893</TD><TD align="right">42</TD></TR><TR><TD height="19">A1</TD><TD>B3</TD><TD>Z</TD><TD align="right">13,8733</TD><TD align="right">14</TD></TR><TR><TD height="19">A1</TD><TD>B3</TD><TD>W</TD><TD align="right">21,4618</TD><TD align="right">21</TD></TR></TBODY></TABLE><P></P><P>Any idea to reach that?</P><P></P><P>Thanks!</P></BODY></HTML> Fri, 22 Mar 2013 16:20:08 GMT https://community.qlik.com/t5/QlikView/Rounding-problem/m-p/470355#M697137 2013-03-22T16:20:08Z Re: Rounding problem https://community.qlik.com/t5/QlikView/Rounding-problem/m-p/470356#M697138 <HTML><HEAD></HEAD><BODY><P>Hi use the CEIL function</P><P></P><P>...</P><P>NUM(CEIL(val, 0.1), '#.#00')</P><P>...</P></BODY></HTML> Fri, 22 Mar 2013 16:38:28 GMT https://community.qlik.com/t5/QlikView/Rounding-problem/m-p/470356#M697138 2013-03-22T16:38:28Z