edit expression

[#1]

Please could someone please help.   What's the wrong with this expression

=sum({<Directorate = 'Surgical Services'>}[planned activity]

[rwunderlich]

You are missing a right paren at the end of the expression.

=sum({<Directorate = 'Surgical Services'>}[planned activity] )

-Rob

http://robwunderlich.com

[#3]

oops sorry Rob i do have the left ) just didn't post it correctly on the discussion.

could u think of anything else because expression is ok but not getting a result for some reason

Thanks

[SunilChauhan]

use the below code

sum({<Directorate = {"Surgical Services"}>}[planned activity] )