Hi Fredrik,
Yes - I just verified your improvement recommendation. If you return Missing in the Else clause for FilteredOrderTotal then you can change the aggregation to Average and it returns the correct value.
Thanks for the improvement recommendation.
Teri
... View more