expression symbol

[nareshthavidishetty]

Hi,

I have used the  #,##0.0% ▲;  #,##0.0%▼ as number format to give symbols to my expression based on some color condition.

But I'm getting the results as below,

We are getting the same up triangle for both the conditions.

logic used:

sum({$<[Month Abbr]=, Year=, [Quarter Name]=, [Date Extract]={'>$(=AddMonths(max([Date Extract]),-6))<=$(=AddMonths(max([Date Extract]),-5))'}, [QN Age 30+ Days]={1}>} [# Open]) /

  sum({$<[Month Abbr]=, Year=, [Quarter Name]=, [Date Extract]={'>$(=AddMonths(max([Date Extract]),-6))<=$(=AddMonths(max([Date Extract]),-5))'}>}[#  Open])) *100

Thanks..

[lironbaram · Accepted solution]

hi

the number format   #,##0.0% ▲;  #,##0.0%▼

specifics what is the format for positive and negative values , as both of your number are positive

you get the same number format ,

you can use num function in your expression to change the format according to your conditon

for example

if(EXPRESSION > 50 , num(EXPRESSION, '#,##0.0% ▲'),num(EXPRESSION, '#,##0.0% ▼'))