Background color for an expression

Tue, 23 Jul 2013 15:37:54 GMT

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 ????

Re: Background color for an expression

swuehl — Tue, 23 Jul 2013 15:46:07 GMT

>> 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)

)