Hi there!
Is there a way to perform a SUMIF without using SQL? That would be very useful to calculate shares (eg how much parner A sales represent over the total sales?)
Hi @lucas.lima
Not currently. Isn’t SUMIF an Excel function?
I would guess you’re talking about something like SUM(CASE WHEN ... THEN ... ELSE ... END) or SUM(IF(..., ..., ...))?
https://github.com/metabase/metabase/issues/3990
https://github.com/metabase/metabase/issues/6331
Yeah, it is. I was talking about the concept, though.
In MySQL, I do SUM(IF(condition, value_to_sum, 0)) and my intention would be doing the same via query builder, precisely to let my users calculate share via one question, rather than calculation the total, and then fitlering and calculation the other number. I just thought the keyword SUMIF would lead to quicker results, but I guess I was wrong lol
Upvoted issues, thanks!