Mismatch agrregation error

Question & Answer
, ,
1

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})

2

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

3

Hi @pantelis,
It’s been awhile since we last heard from you, did you have any additional questions regarding your post?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you!

4

Hi @pantelis,
Since we have not heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.

Thank you!