Mismatched aggregation issue when dividing

Hi, i want to calculate the average frequently rate = total of purchases over a period/ total of customers during that same period but it said error

Thanks in advance !


This works for me.

What is your sum_app_quantity field as well? Also, is your transcation_order_id an aggregation?