HANA Aggregation skipping lines
I have a query regarding HANA aggregations. Currently, I am aggregation some amounts based on the Vendor Id and Vendor name.
From the business perspective I am expecting a total of 77 records, but when as I debugged I noticed that it is skipping three records,
Aggregating only 74.
See the image attached below
After searching, I noticed that It is skipping the three records. There are a few records that have the same amount. HANA is only choosing one of each, whereas the correct business behavior is to choose all three even if they have the same amount. See image below:
The three values hightlighted are skipped. Is there a workaround or a property that will not allow it to skip or is it just a design constraint?
Thank you for your help,