Creating an exception when a value differs based on a given criteria.

[ll98]

Hi - Community -- I'll like to generate an exception where Multiple differs if they fall under same deal name and Investment Date.  In the example attached -- Deal 6 is the outlier when the Multiple differs between the funds.

[Qiu · Accepted solution]

@ll98 
By "Exception" I interprete that it should be filtered out.

We can use a summarize tool to count the distinct Multiple for each combination of "Deal" and "Investment Date"

[ll98]

@Qiu   Thanks Qiu for common in the clutch.....