topic Re: Text color expression in App Development

Text color expression

Alonal148 — Sat, 18 Jan 2020 19:52:29 GMT

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

Re: Text color expression

lorenzoconforti — Sat, 18 Jan 2020 20:18:42 GMT

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

Re: Text color expression

Kushal_Chawda — Sat, 18 Jan 2020 21:37:23 GMT

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

Re: Text color expression

Alonal148 — Sun, 19 Jan 2020 06:46:16 GMT

It is not working

Re: Text color expression

lorenzoconforti — Sun, 19 Jan 2020 11:07:46 GMT

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

Re: Text color expression

Alonal148 — Fri, 24 Jan 2020 06:55:17 GMT

Thank you very much

Re: Text color expression

Alonal148 — Fri, 24 Jan 2020 06:56:43 GMT

Thank you very much for your help.

The problem was sloved