expression error

[#1]

Hi

Can anyone advise what may be wrong with this expression?

=if([[Risk Category]}) = Copers,'#FFF042'

=if([[Risk Category]}) = Struggler,'#FF0000',

Risk Category is a field within the data.

Cheers

Chris

[#2]

Hi,

Try these:

=if([Risk Category] = Copers,'#FFF042' )

=if([Risk Category] = Struggler,'#FF0000')

If you need them nested into one, try this:

=if([Risk Category] = Copers,'#FFF042' ), if([Risk Category] = Struggler,'#FF0000'))

Matt

[kaushiknsolanki]

Hi Matt,

     Try this.

     if([Risk Category] = 'Copers','#FFF042', if([Risk Category] = 'Struggler','#FF0000'))

Regards,

Kaushik Solanki