I want to use ifelse and sumIf in a calculated field together but there is an aggregation mismatch error. This is the scenario: I want to use the ifelse to switch between parameters ${Params} and the sumIf to compute a ratio over another parameter. For instance, this is what I intend to calculate: …

I used the approach below, and it seems to work fine: coalesce( sumIf({A}, Date = ${SelectedDate}) / sumIf({E}, Date = ${SelectedDate}) * ifelse(${Params} = ‘First’, 1, NULL), sumIf({B}, Date = ${SelectedDate}) / sumIf({E}, Date = ${SelectedDate}) * ifelse(${Params} = ‘Second’, 1, NULL), sumIf({…

Using ifelse and Sumif

Q&A

Wakana March 12, 2025, 1:40am 2

hi @Sarmie ,

Welcome to Quick Sight Community!

for aggregation mismatch error, we have an article to explain how to resolve.

Would you be able to try to see if you can resolve the error?

Topic		Replies	Views
Quick Sight Calculated Field Error Q&A quick-sight , calculations , Business-Intelligence-Engineer	2	376	January 31, 2024
Mismatch Aggregation error HELP Q&A quick-sight , how-to	3	316	June 21, 2023
Calculated field using ifelse Q&A analysis , quick-sight , calculations	2	3270	February 23, 2023
Mismatched aggregation. Custom aggregations can't contain both aggregated and nonaggregated fields, in any combination error Q&A error , quick-sight , calculations , Business-Intelligence-Engineer	3	4021	April 18, 2024
Mismatch aggregation Q&A quick-sight , calculations	1	378	July 20, 2023

Using ifelse and Sumif

Related topics