Text color expression

[Alonal148]

Hi,

Plese advice why the follow expression is not correct.

I need to color the text if the measure [Balance High level - trans %] > 0.02.

=IF([Balance High level - trans %]>0.02, Red(),Black())

Than you,

Alona

[lorenzoconforti]

You are not using any aggregation so, unless [Balance High level - trans %]  is one of your dimensions, it's not likely to work

Try:

=IF(sum([Balance High level - trans %])>0.02, Red(),Black())

[Kushal_Chawda]

Ideally it should work. Can you provide more details? where you are using this expression?

[Alonal148]

It is not working

[lorenzoconforti]

It should work; a couple of things to check

- is [Balance High level - trans %] a measure in the same table you are trying to apply colour to? Can you post a picture of such table to see how it looks like?

- are you certain you are writing exactly the name of the measure/column correctly?

- is  [Balance High level - trans %] a master measure? if that's the case, I don't think it will work

[Alonal148]

Thank you very much

[Alonal148]

Thank you very much for your help.

The problem was sloved