https://community.qlik.com/t5/QlikView/Divide-aggregation-expression-with-total-value/m-p/1794685#M1211055 <P>Thank you so much.&nbsp; It's working.</P> Fri, 26 Mar 2021 04:53:19 GMT sunitha_chellaiah 2021-03-26T04:53:19Z https://community.qlik.com/t5/QlikView/Divide-aggregation-expression-with-total-value/m-p/1794354#M1211011 <P>Hi,&nbsp;</P><P>Please see below screenshot. I want to create a new percentage column.</P><P>I want to divide each row value with the total value. for eg. 0.14/2.73 = 5.12%</P><P>I am using below mentioned expression to calculate Discount in R.S</P><P>sum(aggr((sum(DISTINCT D.BILLED_MAKING_CHARGES)-sum(DISTINCT D.MAKING_SP)),D.VOUCHER_NO,D.LABEL_NO))</P><P>Please help me with the expression to calculate percentage.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="sunitha_chellaiah_0-1616666338544.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/51804i6AD8F585ED82BA1D/image-size/medium?v=v2&amp;px=400" role="button" title="sunitha_chellaiah_0-1616666338544.png" alt="sunitha_chellaiah_0-1616666338544.png" /></span></P><P>Thanks</P><P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/46628">@sunny_talwar</a>&nbsp;: Please help</P> Thu, 25 Mar 2021 10:50:27 GMT https://community.qlik.com/t5/QlikView/Divide-aggregation-expression-with-total-value/m-p/1794354#M1211011 sunitha_chellaiah 2021-03-25T10:50:27Z https://community.qlik.com/t5/QlikView/Divide-aggregation-expression-with-total-value/m-p/1794438#M1211017 <P>have you tried</P><P><SPAN>sum(total aggr((sum(DISTINCT D.BILLED_MAKING_CHARGES)-sum(DISTINCT D.MAKING_SP)),D.VOUCHER_NO,D.LABEL_NO))</SPAN></P> Thu, 25 Mar 2021 13:09:24 GMT https://community.qlik.com/t5/QlikView/Divide-aggregation-expression-with-total-value/m-p/1794438#M1211017 yassinemhadhbi 2021-03-25T13:09:24Z https://community.qlik.com/t5/QlikView/Divide-aggregation-expression-with-total-value/m-p/1794685#M1211055 <P>Thank you so much.&nbsp; It's working.</P> Fri, 26 Mar 2021 04:53:19 GMT https://community.qlik.com/t5/QlikView/Divide-aggregation-expression-with-total-value/m-p/1794685#M1211055 sunitha_chellaiah 2021-03-26T04:53:19Z