I have a fixed roster that has 4 options. (Q806b_roster)
Within the roster I have a question that takes the amount spent for each category. (Q806b)
I need to make a variable that takes the sum of the first 3 options. (Exclude option 4).
Currently I have the following code in a long integer variable. Q806b_roster.Sum(x=>x.Q806b). This gives me the sum of all 4 options. I need to sum only the first 3 options.

Thank you for the concern Sergiy. Your intuition about the 4th option being the Total is correct. Here, we allow them to record ‘don’t know’ for the breakdowns (first 3 options). But the total is always required. Hope this makes sense.