Problems with color text in pivot table

[oscargm_bi]

Hi all,

I have this expression in a measure of a pivot table:  if(avg([Importe Est. Moneda CTV]) > 44000,'red','green') that makes if the average of the "importe..." its > 44.000 turn red the value o green if its not. 

Everything works fine, but when I add the Totals of the dimension, the data always turn in red without fulfill the conditional.

Attach there is a image of the problem.

Thanks in advance.

Regards

[juliensaintmaxent3113]

hello,

the total is correct?

I think you gotta to specify the dimension which you want to calcul the average condition  avg(total <dim1,dim2,...>KPI)

Bye