Multi row calculations within specific row id

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.

Test File.xlsx

Preparation

Data Investigation

Accepted answers

Raj

@Nyk_Ton Please find the workflow attached

mark done if solved.

1175.yxzp

All comments

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

@Nyk_Ton Please find the workflow attached

mark done if solved.

1175.yxzp

Nyk_Ton

thanks Raj , this works

Raj

@Nyk_Ton happy to help

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335