Morning, This sounds like a really simple question and i'm sure i'm going to kick myself when i see the answer but here goes. 2 coloums, A and B. Column A has True or False in and Column B has a number. I want to be able to sum all numbers in Column B upon column A being True Thanks

Hi, You can use following expression: =SUM(IIF(Fields!A.Value = true, Fields!B.Value, 0)) Thanks