Divide aggregation expression with total value

[sunitha_chellaiah]

Hi, 

Please see below screenshot. I want to create a new percentage column.

I want to divide each row value with the total value. for eg. 0.14/2.73 = 5.12%

I am using below mentioned expression to calculate Discount in R.S

sum(aggr((sum(DISTINCT D.BILLED_MAKING_CHARGES)-sum(DISTINCT D.MAKING_SP)),D.VOUCHER_NO,D.LABEL_NO))

Please help me with the expression to calculate percentage.

Thanks

@sunny_talwar : Please help

[yassinemhadhbi · Accepted solution]

have you tried

sum(total aggr((sum(DISTINCT D.BILLED_MAKING_CHARGES)-sum(DISTINCT D.MAKING_SP)),D.VOUCHER_NO,D.LABEL_NO))

[sunitha_chellaiah]

Thank you so much.  It's working.