"Mismatched aggregation - custom aggregations can't contain both aggregated and non-aggregated fields

When creating the following calculated field:
“{assets_current_month}+{disposal_EV}+{disposal_ICE}”. I get an error “mismatched aggregation”.
asset_current_month is a calculated field (current_16403+current_16409)
The disposal ICE/EV are calculated fields.
current_16403 and current 16409 are not calculated field

Could you guide/help me fix the error?

@baltoman The error you are seeing is telling you “What you are trying to do is not allowed / possible in QS”

Try to do assets_current_month + disposal_EV at the source level. Or use custom_sql if possible.

1 Like

hi @baltoman,

did the solution provided by @neelay help you solve your question? if so please help us mark it as Solution. otherwise, let us know please.

kind regards,
Wakana

Hello @baltoman !

It has been some time since we have heard from you but would still like to help you find a solution. If we do not hear from you in 3 days this post will be archived.