Populating Custom Attribute in Reconciliation Dashboard

Hi All,

We are trying to calculate the RAG (Red, Amber, Green) status for one of our customer.

Objective: Customer wants RAG (Item & Reconciliation level) to be populated on Reconciliation dashboards.

In order to achieve customer requirement we created a Custom attributes to calculate RAG status for each adjustments, we are able to see the calculated RAG values for each adjustments for reconciliation.

However when we try to create a custom attribute to calculate RAG status at Reconciliation level, we couldn't able to populate RAG for each reconciliation ID based on Item level RAG. The criteria to populate Reconciliation level RAG is to get the MAX RAG status based on item level RAG