How to Calculate the median, from the Value of Rule Inputs for individual item in an Cascading dropdown

Hello Everyone,

I have an editable Grid, which contains a Cascading Drop down as shown below, where as the category displays 'MI' and Skills pop up related to that. I also have multiple values as such. And i can add more rows to it.

The following is the Rule Input

Now, how can I to have a median calculated based on "ri!CC_Person.skills.Rating" only for 'MI' even though I add more rows and select 'MI' with the rating.

Thanks in advance..!!


 Discussion posts and replies are publicly visible