topic Straight table sum up 4 row data , how to make it display 159,141 ? in QlikView https://community.qlik.com/t5/QlikView/Straight-table-sum-up-4-row-data-how-to-make-it-display-159-141/m-p/1165481#M631435 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P></P><P>I got the below expression from Ram :-</P><P></P><P></P><P>'S$ ' &amp; Num(If ( US_Cust='USD', 1.3,if(US_Cust='EU',1.5, 1)) *Num(</P><P>sum(days3) + sum(days6) + sum(days9) + sum(above12)+sum(curren)</P><P>,'###,##0.00'),'###,##0')</P><P></P><P></P><P>But when it sum up the 4 row of data , it display S$ 118,299 , which is wrong , How to make it display 159,141 ?</P><P></P><P></P><P>Paul</P></BODY></HTML> Thu, 28 Jul 2016 07:32:46 GMT paulyeo11 2016-07-28T07:32:46Z Straight table sum up 4 row data , how to make it display 159,141 ? https://community.qlik.com/t5/QlikView/Straight-table-sum-up-4-row-data-how-to-make-it-display-159-141/m-p/1165481#M631435 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P></P><P>I got the below expression from Ram :-</P><P></P><P></P><P>'S$ ' &amp; Num(If ( US_Cust='USD', 1.3,if(US_Cust='EU',1.5, 1)) *Num(</P><P>sum(days3) + sum(days6) + sum(days9) + sum(above12)+sum(curren)</P><P>,'###,##0.00'),'###,##0')</P><P></P><P></P><P>But when it sum up the 4 row of data , it display S$ 118,299 , which is wrong , How to make it display 159,141 ?</P><P></P><P></P><P>Paul</P></BODY></HTML> Thu, 28 Jul 2016 07:32:46 GMT https://community.qlik.com/t5/QlikView/Straight-table-sum-up-4-row-data-how-to-make-it-display-159-141/m-p/1165481#M631435 paulyeo11 2016-07-28T07:32:46Z Re: Straight table sum up 4 row data , how to make it display 159,141 ? https://community.qlik.com/t5/QlikView/Straight-table-sum-up-4-row-data-how-to-make-it-display-159-141/m-p/1165482#M631436 <HTML><HEAD></HEAD><BODY><P>my QVW</P></BODY></HTML> Thu, 28 Jul 2016 07:33:29 GMT https://community.qlik.com/t5/QlikView/Straight-table-sum-up-4-row-data-how-to-make-it-display-159-141/m-p/1165482#M631436 paulyeo11 2016-07-28T07:33:29Z Re: Straight table sum up 4 row data , how to make it display 159,141 ? https://community.qlik.com/t5/QlikView/Straight-table-sum-up-4-row-data-how-to-make-it-display-159-141/m-p/1165483#M631437 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try this.</P><P></P><P>'S$ ' &amp;Num(</P><P>sum(If ( US_Cust='USD', 1.3,if(US_Cust='EU',1.5, 1)) * days3) </P><P>+ sum(If ( US_Cust='USD', 1.3,if(US_Cust='EU',1.5, 1)) * days6) + </P><P>sum(If ( US_Cust='USD', 1.3,if(US_Cust='EU',1.5, 1)) * days9) + </P><P>sum(If ( US_Cust='USD', 1.3,if(US_Cust='EU',1.5, 1))*above12)+</P><P>sum(If ( US_Cust='USD', 1.3,if(US_Cust='EU',1.5, 1)) * curren)</P><P>,'###,##0.00')</P><P></P><P></P><P>Regards,</P><P>Kaushik Solanki</P></BODY></HTML> Thu, 28 Jul 2016 07:45:02 GMT https://community.qlik.com/t5/QlikView/Straight-table-sum-up-4-row-data-how-to-make-it-display-159-141/m-p/1165483#M631437 kaushiknsolanki 2016-07-28T07:45:02Z Re: Straight table sum up 4 row data , how to make it display 159,141 ? https://community.qlik.com/t5/QlikView/Straight-table-sum-up-4-row-data-how-to-make-it-display-159-141/m-p/1165484#M631438 <HTML><HEAD></HEAD><BODY><P>Wow this is good, Thank a lot</P></BODY></HTML> Thu, 28 Jul 2016 07:53:42 GMT https://community.qlik.com/t5/QlikView/Straight-table-sum-up-4-row-data-how-to-make-it-display-159-141/m-p/1165484#M631438 paulyeo11 2016-07-28T07:53:42Z Re: Straight table sum up 4 row data , how to make it display 159,141 ? https://community.qlik.com/t5/QlikView/Straight-table-sum-up-4-row-data-how-to-make-it-display-159-141/m-p/1165485#M631439 <HTML><HEAD></HEAD><BODY><P>Now i am able to sort from hi to lo. </P></BODY></HTML> Thu, 28 Jul 2016 07:58:50 GMT https://community.qlik.com/t5/QlikView/Straight-table-sum-up-4-row-data-how-to-make-it-display-159-141/m-p/1165485#M631439 paulyeo11 2016-07-28T07:58:50Z