Multi row calculations within specific row id

[Nyk_Ton]

Hello, 

I am stuck with a situation where I have a multiple unique id which have different approval types. Based on the approval on one category , I need to fix the Approval for other categories for a specific unique id. I am attached the sample dataset for reference. 

[Raj]

@Nyk_Ton can you explain the logic of approval.

[Nyk_Ton]

Hello Raj ,

The approval chain goes as Student , Teacher 1 , Teacher 2 (if Applicable) and then mentor .

We need to look at the Role decision of the "Mentor". If for a particular record id , the mentor has approved the record then we need the result as approved against all rows for that record id (irrespective of whether teacher1 or teacher 2 has approved or not).

[Raj · Accepted solution]

@Nyk_Ton Please find the workflow attached

mark done if solved.

[Nyk_Ton]

thanks Raj , this works 

[Raj]

@Nyk_Ton happy to help