Remove % Symbol

[nareshthavidishetty]

Hi,

How to remove the '%' symbol in the below chart.

Thanks..

[sunny_talwar]

Are you using formatting in the expression (using Num) or are you using Number tab's formatting?

[devarasu07]

Hi,

to remove % symbol from bar values

Go to Chart properties --> number tab --> uncheck for show in percent (%)

Thanks

Dev

[johanlindell]

Add a second expression with different formatting and no bars.

[giakoum]

[el_aprendiz111]

Hi

[giakoum]

cool

[nareshthavidishetty]

Hi Sunny,

i'm used the num in the expression.

Logic: num(aggr(sum({<Date={$(varMaxDate)},flag={'e_Inititated'}>} Contracts),Location,District)/aggr(sum({<Date={$(varMaxDate)},flag={'Daily_Total'}>} Contracts),Location,District),'#,##0%')

Thanks..

[sunny_talwar · Accepted solution]

How about this?

Num(Aggr(Sum({<Date={$(varMaxDate)},flag={'e_Inititated'}>} Contracts),Location,District)/Aggr(Sum({<Date={$(varMaxDate)},flag={'Daily_Total'}>} Contracts),Location,District) * 100,'#,##0')

[antoniotiman]

Num(YourExpression*100,'#.##0')  (or , instead of . according to Your separator)

and in Tab Number check 'Default Expression'