script error

[#1]

Hi,

Can anyone advise how this script can be corrected:

=Sum(Enforcement)='COMPLIANCE''#0000FF'

=Sum(Enforcement)='ENFORCEMENT''#000000'

This first sentence works fine on its own; however, add the second and it says 'Garbage after expression "-"'

Any help would be appreciated

Chris

[#2]

why have u written script like this?

is it expression?

Where did u write the expression?

[#3]

Is it the 'colour expression' within our Map properties....we want to colour the results by either ENFORCEMENT or COMPLIANCE.

Cheers

Chris

[er_mohit]

try this

sum(if(wildmatch(Enforcement,'COMPLIANCE''#0000FF','ENFORCEMENT''#000000'),Enforcement))

or

sum(if(Enforcement='COMPLIANCE''#0000FF' or Enforcement='ENFORCEMENT''#000000',Enforcement))