Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!
Hi
May be replace your format number ('#,##0.0%') by this one :
'▲ #,##% ;▼- #,##%'
Hi
May be replace your format number ('#,##0.0%') by this one :
'▲ #,##% ;▼- #,##%'
@brunobertels Great! Its working. Thanks for your timely help!!