Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
My data contains two columns: Amount and Category. The category column has three options: B, C, and O. I would like to add an expression that would only look at the sum for category "B" or "O" or both "B+O". I am looking for some help with the syntax
Maybe
sum(if(Category = 'B' or Category = 'O', Amount))
resp.
sum({<Category = {'B','O'}>} Amount)
Maybe
sum(if(Category = 'B' or Category = 'O', Amount))
resp.
sum({<Category = {'B','O'}>} Amount)