Hi All,
I am sticking at one report. please find below final output.
CPTY ID CPTY Full Name Pricer_NPV_BASE Expected Exposure 14D Expected Exposure Trade System Name
50000 ABC 1000 -2900 XYZ
50000 ABC 1000 -2900 498 XYZ
67464 MNO -242 78 CDF
50000 MNO -242 78 320 CDF
Please observe the above pattern. how to remove the null duplicate record.
note : I cant use filter like 14D Expected Exposure is not null because expected exposure calculation based on other records.
Ignoring the 14D column, it looks like there's only one duplicate. Is the problem always happening with 14D? You might do the filter with it set to after auto-aggregation. Is it possible for 14D to have multiple values?
Is this a valid output?
CPTY ID CPTY Full Name Pricer_NPV_BASE Expected Exposure 14D Expected Exposure Trade System Name
50000 ABC 1000 -2900 123 XYZ
50000 ABC 1000 -2900 498 XYZ
67464 MNO -242 78 CDF
50000 MNO -242 78 320 CDF
If not, you could set that field to be aggregate with sum or max.