Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all ,
added to color by expression the below
num((count(users)/sum(accounts))*100,'#,##0%')
unchecked the expression is a color code , when standing with cursor it shows the correct number without the percentage (%) sign
any ideas?
So what exactly is your issue? You want to see the percentage sign?
yes
Hi ilan,
Try With this expression
=num((count(users)/sum(accounts))*100,'#,##0')&' %'
Regards
Miguel del Valle
Number formatting will not apply in color expression.
in color by expression you don't need to have number formatting with % sign. You just have to decide a proper range and assign colors accordingly.
Expression:
=num((count(users)/sum(accounts)),'#,##0%')
Text Color Expression:
if((count(users)/sum(accounts))<0,RED(),GREEN())
Thank you Miguel , but it didn't work
Can you share some screenshots of what you are seeing?
no but its straight foreword - when standing with cursor on the bubble, in the tooltip i'm seeing the correct number format i.e(2.7) - only the percentage sign (%) is missing
thank you