Color Formatting

[Prachi_SS]

Need to change color only after slash if positive number then it should change to green ,for -ve number change it to red color

e.g.

-5% / 13444

for -5% i.e before slash value no need to change color and after slash for 13444 need to show green color, if it is negative value it should show red color.

[anat]

try using conditional color like

if (sum(sal)>0,green(),red())

[Prachi_SS]

I have tried using this scenario but expression got applied completely not only after slash value. I am not getting expected results.

Thank you for your solution!

[Aditya_Chitale]

Try this :

if(subfield(FieldName,'/',-1) > 0 , green() , if(subfield(FieldName,'/',-1) <  0 , red()))

Regards,

Aditya

[anat]

assuming you are using single text object to show "-5% / 13444"  value,try to use 2 text objects and apply above condition for color.