Table chart : Text Color Expression with ‌Upwards and Downwards Symbol

[Purushothaman]

Hi Experts,

My Requirement is add Upwards🔼   and Downwards Symbol🔽 in Table chart under Text Color Expression.

Below is the image example:

Below is the my Text Color expression;

if((

NUM(


SUM({<BrGrp1,BrGrp2,[Year Base],[Year Half Base],[Year Quarter Base],[Year Month Base],Year_Offset={"0"},[Year Month_Offset]={"0"},[Year Quarter Offset]={"0"},[Year half year offset]= {"0"},YTDFlag = {"0"},[Year Month Base (YYYYMM)]={">=$(vMonth_Min) <=$(vMonth_Max)"}>}VV)
/
SUM(TOTAL <COUNTRY,PRICESEG,[Year Month Base],[Year Quarter Base],[Year Half Base]>{<BrGrp1,BrGrp2,[Year Base],[Year Half Base],[Year Quarter Base],[Year Month Base],Year_Offset={"-1"},[Year Month_Offset]={"0"},[Year Quarter Offset]={"0"},[Year half year offset]= {"0"},YTDFlag = {"0"},[Year Month Base (YYYYMM)]={">=$(vMonth_Min) <=$(vMonth_Max)"}>}VV)

-

SUM({<BrGrp1,BrGrp2,[Year Base],[Year Half Base],[Year Quarter Base],[Year Month Base],Year_Offset={"0"},[Year Month_Offset]={"0"},[Year Quarter Offset]={"0"},[Year half year offset]= {"0"},YTDFlag = {"0"},[Year Month Base (YYYYMM)]={">=$(vMonth_Min) <=$(vMonth_Max)"}>}VV)
/
SUM(TOTAL <COUNTRY,PRICESEG,[Year Month Base],[Year Quarter Base],[Year Half Base]>{<BrGrp1,BrGrp2,[Year Base],[Year Half Base],[Year Quarter Base],[Year Month Base],Year_Offset={"0"},[Year Month_Offset]={"0"},[Year Quarter Offset]={"0"},[Year half year offset]= {"0"},YTDFlag = {"0"},[Year Month Base (YYYYMM)]={">=$(vMonth_Min) <=$(vMonth_Max)"}>}VV),'#,##0.0%')

)>0,Blue(),Red())

Anyone, Please help!!

Thank you!!

[brunobertels · Accepted solution]

Hi 

May be replace your format number ('#,##0.0%')  by this one  : 

'▲  #,##% ;▼-  #,##%'

[Purushothaman]

@brunobertels  Great! Its working. Thanks for your timely help!!