AGGR based on a Group of Field - Values changes if i drill down
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.
