Thanks HTH. Yeah that's what I was working on and actually made good progress until I ran into another issue. I will post post the 3 formulas that I have and the reslut a bit later.
I tried something else and that got me actually further. Here is what I tried instead:
If (({calculation formula for PO Amount} = previous ((({calculation formula for
PO Amount})) and ({EKKN.EBELN}) =({EKKN.EBELN})) then 0 else{calculation formula
for PO Amount}
I also use a sorting function due to the previous so I have no mix matches and get the result I need.
This formula above returns single values as I want and sets duplicates to 0.
The issue I ran into is: The very first value which should be an amount comes back blank. Not sure why and how to get over it.
Any suggestion?
Thanks,
S