How can I do a sum distinct function in the worksheet? I’m looking for Sigma’s equivalent to Snowflake’s sum distinct function: https://docs.snowflake.com/en/sql-reference/functions/sum.html
I think the SumIf() function should do the trick for you, this sums up values only if a certain condition is met. Check out the help article below on how to use this!
I don’t know if we can specify distinctness as a condition in SumIf(). You may have to first create a grouping level for the column in question and then call Sum() or SumIf() from a higher level.