GROUP BY - Exclude on MAX

Hi all,

My input Data set

then i have a formula field called CHECK where i have the condition.

IF SUB PRODUCT STATUS ='LIVE' AND SP DOC C = FIRST AND SP DOC SC = OK THEN YES ELSE NO

Then i'm using a summarize tool to GROUPBY PROD ID_22 and do a Max_CHECK..( the reason for doing a MAX is i want to treat if any of my (A1,A2,A3,A4) satisfies the condition on CHECK column then treat my siblings as YES but exclude A4 since A4 Doesn't satisfies the CHECK column condition

Expected Output.

Attached the sample workflow.

GROUP BY.yxmd

Common Use Cases

Accepted answers

atcodedog05

Hi @suby

ok got it. Here is what can we done instead of filtering it out, it is set to "No" when its not Null or doesnt meet any one of the condition. If its Null or meets the condition then its "Yes"

Workflow:

Hope this helps 🙂

GROUP BY.yxmd

All comments

atcodedog05

Hi @suby

Here is how you can do it. As per what i can understand you are applying "yes" value to siblings and later you are again checking it, if any of the condition are not met (i,e its ok if they are null but if its not matching then it needs to be filtered). Based on that we need to add a filter like below.

The columns should match the value or be Null.

Hope this helps 🙂

GROUP BY.yxmd

suby

Hi,

Thanks and i got your point.

But i don't want to restrict the results by adding a filter.

I'm trying to understand is there a better way to acheive this.

Also by using MAX and also at the same i want to Exclude A4 is that possible without adding a filter.

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335