Set Analysis Multiple Excludes - Pls Help!

[#1]

Hi there

I have 3 expressions in a table with multiple exclusions like:

=

sum({$<[Summary L2] -= {'Overtime'},[Summary L1] -= {'Doctors Overtime'},[9CCC - Level 9 Cost Centre Code] -= {'11912','90000'}>} [Amount_(Element_Cost_Amount+Er_Pension+ER_NI_Cost])

=

sum({$<[Summary L2] -= {'Overtime'},[Summary L1] -= {'Doctors Overtime'},[9CCC - Level 9 Cost Centre Code] = {'11912'}>} [Amount_(Element_Cost_Amount+Er_Pension+ER_NI_Cost])

=

sum({$<[Summary L2] = {'Overtime'},[9CCC - Level 9 Cost Centre Code] -= {'90000'}>} [Amount_(Element_Cost_Amount+Er_Pension+ER_NI_Cost])+sum({$<[Summary L1] = {'Doctors Overtime'},[9CCC - Level 9 Cost Centre Code] -= {'90000'}>} [Amount_(Element_Cost_Amount+Er_Pension+ER_NI_Cost])

These give me results but the result of this:

=

sum({$<[9CCC - Level 9 Cost Centre Code] -= {'90000'}>} [Amount_(Element_Cost_Amount+Er_Pension+ER_NI_Cost])

should equal the sum of the other 3 but doesn't?? Please can anyone correct my syntax?

Thanks!