Expression Syntax

[#1]

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

[swuehl · Accepted solution]

Maybe

sum(if(Category = 'B' or Category = 'O', Amount))

resp.

sum({<Category = {'B','O'}>} Amount)