Hi All, Is there a way to average a group of values based on a condition? Below is my example. Data Set: ITEM QTY Canceled Apples 3 0 (Bool Type) Apples 8 1 Apples 5 0 Report Structure & Expected Results Example ITEM Average Canceled Apples 4 1 (3+5)/2 (3+8+5)/3 What I have to avoid is including the QTY value if a canceled condition exists in the canceled column, in my case because the 8 has been canceled I don’t want this included in my average result. Flexpadawan