Visual Cues issue

[Anonymous]

Hi,

I have created stright table and provided condition to fact field like

Unitcost > 20 (Show in green color)

Unitcost<20 (Show in red)

if you look at the sum(Total)  it also showing in Green color (as like > 20)

How can we limit the color to sum.

Regards,

Sandeep

[MK_QSL]

go to Expression tab

Click on + sign of expression

Write below expression in text color

IF(SUM(Total) > 20, green(), red())

[Anonymous]

Thank you very much for the response.

Expression is not getting validated at Total with IF condition.

IF(SUM(TOTAL)

[MK_QSL]

Provide your sample apps...

[MK_QSL · Accepted solution]

IF(Dimensionality() = 0, Black(),

  IF(SUM(Cost)>200,Green(),Red()))

[Anonymous]

Thank you, Its working now.

[qv_testing]

Hi Sandeep,

Better to use in Expression tab,

Click on taggole button,

Write this expression in "Text Color"

IF(SUM(Cost) > 20, green(), red())