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.
Solved! Go to 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"
@Qiu Thanks Qiu for common in the clutch.....