topic Re: How to summary data same excel? in QlikView https://community.qlik.com/t5/QlikView/How-to-summary-data-same-excel/m-p/1401791#M424826 <HTML><HEAD></HEAD><BODY><P>May be <STRONG><SPAN style="text-decoration: line-through;">Ceil</SPAN>(Sum(Sales))</STRONG></P></BODY></HTML> Fri, 20 Oct 2017 11:23:44 GMT Anil_Babu_Samineni 2017-10-20T11:23:44Z How to summary data same excel? https://community.qlik.com/t5/QlikView/How-to-summary-data-same-excel/m-p/1401789#M424824 <HTML><HEAD></HEAD><BODY><P>I summary data from qlikview as green part but result is not true, how to I got result same as excel summary?</P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/180318_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Fri, 20 Oct 2017 10:06:48 GMT https://community.qlik.com/t5/QlikView/How-to-summary-data-same-excel/m-p/1401789#M424824 panwipa2528 2017-10-20T10:06:48Z Re: How to summary data same excel? https://community.qlik.com/t5/QlikView/How-to-summary-data-same-excel/m-p/1401790#M424825 <HTML><HEAD></HEAD><BODY><P>For me QlikView calculates 39987 for the integer part not 39986 as you have.... do you have a&nbsp; sample QlikView app to share so we can find out why your calculation doesn't add up to 39987?</P></BODY></HTML> Fri, 20 Oct 2017 11:02:50 GMT https://community.qlik.com/t5/QlikView/How-to-summary-data-same-excel/m-p/1401790#M424825 petter 2017-10-20T11:02:50Z Re: How to summary data same excel? https://community.qlik.com/t5/QlikView/How-to-summary-data-same-excel/m-p/1401791#M424826 <HTML><HEAD></HEAD><BODY><P>May be <STRONG><SPAN style="text-decoration: line-through;">Ceil</SPAN>(Sum(Sales))</STRONG></P></BODY></HTML> Fri, 20 Oct 2017 11:23:44 GMT https://community.qlik.com/t5/QlikView/How-to-summary-data-same-excel/m-p/1401791#M424826 Anil_Babu_Samineni 2017-10-20T11:23:44Z Re: How to summary data same excel? https://community.qlik.com/t5/QlikView/How-to-summary-data-same-excel/m-p/1401792#M424827 <HTML><HEAD></HEAD><BODY><P>How about Sum(Ceil(Sales))</P></BODY></HTML> Fri, 20 Oct 2017 12:06:34 GMT https://community.qlik.com/t5/QlikView/How-to-summary-data-same-excel/m-p/1401792#M424827 marcus_malinow 2017-10-20T12:06:34Z