用表变量中的值检查将Case语句求和

I have a report that I am working on, the report has a few parameters passed to it. One of them is a string of UserIds that are operated by commas. These are split and sent into a table variable. In side of my query I need to be able to sum values. In a few of these Sums I need to by case add this value to the sum and in another case not add to it. The code looks something like this...I have a report that I am working on, the repor