Condition Fails,Mismatch Aggregation


I need to do aggregation based on this condition . Any other method Pls suggest

Hi,
Please see this article for more info on this topic, particularly the section at the bottom on handling mismatched aggregation errors.

Thank you.