Skip to Content

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

HANA modelling aggregation issue

Hi Friends,

I am trying to achieve following requirement.

I want one extra coloum showing final status, that should be derived from the Status coloumn, for example, lets say I have three coloums that I am fetching(Complain ID, Item no, and Status) in table.

For Complaint ID 100001, there are two line items both with status as 'Accepted', so in this case I want to populate final status as 'Fully Accepted'.

In second scenario , complaint ID 100002 has just one line item , and it has status as 'Rejected'. In this case I want Final status as 'Fully Rejected'.

And third scenario, for complaint ID 100003, there is 'Rejected' and 'Accepted' status both present, so final status should be 'Partially Rejected'.

I am not sure how can we achieve this. Is it possible to do using aggregation function. If yes kindly suggest how I should do it.

Thanks a lot.

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