Hi,
Why the below gives me the mismatch aggregation error?
I want to find the average amount per Call ID
max({Approved Amount USD)},[{Expense ID}]) / distinct_count({Call ID})
Hi @pantelis
The max is being used in Level Aware context, while the other one is an regular aggregation.
Refer to the article below. There is a section to understand the mismatch aggregation error and how to avoid the same
Regards,
Giri