Aggregation Mismatch

[duncan]

Hello @DBrom and welcome to the Quicksight community!

If you are able to access the dataset, it might be easier to do the calculations in SQL as fields and then calculate the if/then statements in Quicksight.

I also recommend checking out these similar issues that came up in the past to see if Nesting might help:

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

hi getting this type of error (Mismatched aggregation. Custom aggregations can’t contain both aggregated and nonaggregated fields, in any combination.) while using this calculation ifelse(${Selectmeasure}=‘Loan Amount’, [({Loan Status}=‘Current’ OR {Loan Status}=‘Issued’ OR {Loan Status}=‘Fully Paid’),sum({Loan Amnt})] ,[({Loan Status}=‘Current’ OR {Loan Status}='Issued’OR {Loan Status}=‘Fully Paid’),count({Loan Amnt})])

Let me know if this helps!