Background color for an expression

[#1]

Hi,

In a pivot table with date as dimension and a bunch of metrics as colums, i wat a background color for the first expression which is

sum(search)

the expression for determining the bacground color is derived from 2 fields, a mean and a standard deviation

the expn fr the bg color is :

If(Sum(mini_msearch)<<msearch_estimate-msearch_std,RGB(255,142,77),if(Sum(mini_msearch)>>(msearch_estimate+msearch_std),RGB(160,184,231)))

but no matter what numbers i put for 'msearch_estimate'  and 'msearch_std' , it shows only the first color.

Why? wat is wrong with this expn ????

[swuehl · Accepted solution]

>> and << are bit shift operators not comparison operators. Try something like

If(Sum(mini_msearch) < (msearch_estimate-msearch_std),RGB(255,142,77),

     if(Sum(mini_msearch) > (msearch_estimate+msearch_std),RGB(160,184,231)

     )

)