Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
go to Expression tab
Click on + sign of expression
Write below expression in text color
IF(SUM(Total) > 20, green(), red())
Thank you very much for the response.
Expression is not getting validated at Total with IF condition.
IF(SUM(TOTAL)
Provide your sample apps...
IF(Dimensionality() = 0, Black(),
IF(SUM(Cost)>200,Green(),Red()))
Thank you, Its working now.
Hi Sandeep,
Better to use in Expression tab,
Click on taggole button,
Write this expression in "Text Color"
IF(SUM(Cost) > 20, green(), red())