Change of Background Color of Calculated Dimension

[agni_gold]

I have a Calculated Dimension

round(aggr((sum([HFM Value])-sum([ERP Amount USD]))/sum([HFM Value]),[%HFM Base Account]),0.01)

and i have written in backgroud of the dimesion

=if(round(aggr((sum([HFM Value])-sum([ERP Amount USD]))/sum([HFM Value]),[%HFM Base Account]),0.01)>0.20,RGB(255,0,0))

But it is comming like in below pic. Some values are changing color but some are not.

Please help

[Anonymous]

Can you upload an example?

[agni_gold]

PFa the app

[Anonymous]

See if the attached works for you.  I added partial sums on last dimensions, with subtotals on top.

Please attach smaller files next time...

[agni_gold]

Thanks for your great help

But i dont want to show the total here , without total can it possible ?

[Anonymous]

Maybe, but I'd spend more time than I can afford now to find a better solution.  You can hide the numbers using conditional text color for expression, as in the attached update.

[agni_gold]

sorry friend but my client will not accept .

but i also want to know why this color is not chaning for all the values >0.20 as in my initial application ,any specific region ? because for some values it was changing.

If it is possible without using Total, then please help tomorrow i have to give solution.