Below is the Table
| Document |
Customer Code |
Installment |
Original Amount |
Outstanding |
Percentage |
| P1 |
C1 |
1 |
10,000 |
6,000 |
60% |
| P1 |
C2 |
1 |
-5000 |
-5000 |
60% |
| P1 |
C3 |
1 |
-3000 |
-3000 |
60% |
| P1 |
C4 |
1 |
-100 |
-100 |
60% |
| P1 |
C5 |
1 |
-50 |
-50 |
60% |
60% Calculation based on if the Amount is positive, then sum of Outstanding/Original Amount. Till here its working as i am expecting. I was using AGGR here with some if condition. I got the same 60% repeated against all the lines.
But if i click a Customer Code - i dont want the value to change but the 60% is changing to 0% as per the line value.
I tried using AGGR ( NODISTINCT "Percentage" , Document, Customer Code, Installment) but still that 60% was not retained.
