Adding a column based on a logic

[udles5666]

hi Community, 

I am trying to add a column "Compliance Flag" (Compliant or Not Compliant) based on a logic. 

Logic: 

If the Amount Column in the data set for a particular product has different value or doesn't align then it should be flagged as "Not compliant". 

As an example - Butter has 13, 14 & 18.87 in the amount so, that will be Not Compliant

As an example - Bread has 3.33 in the amount for all the rows so, that will be Compliant

Attached workflow for reference. Thanks in advance. 

[chuckleswk · Accepted solution]

 You can use a Summarize to group the Descriptions and the Amounts and then another Summarize to group by the Description and count those followed by a formula tool that is going to populate your Compliant and Not Compliant flag.

 

[chuckleswk · Accepted solution]

@udles5666 If this solution works for you, please mark it so that others can find / use it.