Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
Sunny I could achieve the solution using ALT function..... thanks & Regards