Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

HANA Aggregation skipping lines

Greetings Experts,

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,


Not what you were looking for? View more on this topic or Ask a question