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 !

Hmm,

This works for me.

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