Count with specific conition

[Learner09]

Hello All,

I am trying to prepare a flow that counts the uniques based on specific conditions. Please see the attached Excel for details.

Thanks,

Mayank

[aatalai]

@Learner09 put this into a formula tool  If [Type]="Closed" and [Condition]="No" then 1 else 0 endif

[Learner09]

@aatalai thank you for the flow, however, there is some update required. see the attached example. I need unique count, but flow provided the duplicate counts.

[aatalai]

@Learner09 would adding a unique do the trick, like the workflow attached?

[binuacs · Accepted solution]

@Learner09