Mismatched aggregation. Custom aggregations can't contain both aggregated and nonaggregated fields, in any combination error

[Ciku]

I am getting the error when I try to run the calculation below. What’s the alternative please
ifelse({countryname} = ‘Malaysia’,
sum({five_sec}) / sum({total}),
sum({five_sec}) / (sum({total}) - sum({attempted}))
)

[duncan]

Hello @Ciku !

I found this article very helpful when trying to trouble shoot that error:

Finding solutions for mismatched aggregation errors in QuickSight calculations

Finding solutions for mismatched aggregation errors in QuickSight calculations Mismatched aggregation errors are common QuickSight calculation errors reported by users. This error occurs when the calculated field contains both aggregated and non-aggregated (row-level) values. For users new to QuickSight, it’s not always apparent what causes this error. It is important to understand what is aggregated vs non-aggregated from a QuickSight perspective. This article explores common cases where these …

Let me know if this helps!

[duncan]

Hello @Ciku !

Were you able to take a look at the blog I linked above, and if so were you able to resolve the issue above?

[Ciku]

No, and I am still facing the same issue with another formula.
I have the following formula
ifelse(dateDiff(datevalue,now(),“MI”) <61, count(paymentID),0).

I have tried to create a separate calculated field for total count count(paymentID)=
and replaced it on the formula to become ifelse(dateDiff(datevalue,now(),“MI”) <61, total count,0). but it’s still not working.