How to divide the value of each row by the sum of a column in qlikview

[tahreen371]

Hello All,
Based on CLEARING_DOCUMENT_NUMBER Sum up the Doc.Amount and that total Doc.Amount should be divided with every value of Doc.Amount related to every Doc_number to achieve PAYMENT COLUMN

And to get the Balance Column every value of the Payment column should be multiplied with Sum of payment marked in red.

[sunny_talwar]

Is Doc.Amount a field or expression here?

[tahreen371]

Thanks for your response Sunny.. But that part is achieved by this logic [sum(Amt)/sum(TOTAL Amt) ] and also achieved Payment Column : sum(Total Payment)*(sum(Amt)/sum(TOTAL Amt))

But now i have got a different problem... that is if any value in Amount(Amt) Column is 0 than i get no result for that row in payment and Balance column.

How do i achieve this?? Can anyone help??

Thanks & Regards.

[tahreen371]

Sunny I could achieve the solution using ALT function..... thanks & Regards