% in expression

[#1]

Is it possible to add "%" sign to a number in expression?

here is my diagram:

Now, I would like to add "%" sign to every value, for example in diagram you can see "7.1". I would like it to be "7.1%"

Thanks!

[MK_QSL · Accepted solution]

In expressions, please untick value on data points.

Add same expression with &'%'

i.e. SUM(Sales) &' %'

Here untick bar and tick value on data points

[swuehl]

Maybe divide your expressions by 100 and set number format in number tab to percentage?

[#4]

Thanks! It is exactly what I wanted to do!

I have another question (not related to editing the chart).
here is the situation:  I have two tables

Table A attributes: Age, "Total Population", "Mobile User (Unique User)"

Table B attributes: Sex, "Total Population", "Mobile User (Unique User)"

When I reload the script, my first chart (based on Table A) goes crazy.
What should I do in order to analyse the two tables separately?

Thanks!

[#5]

Num(Sum(Sales ),'##,#0%') This is Num()

[#6]

I do not understand
Could you elaborate on this please?

[#7]

Sorry, I was thinking you are referring to my second question - the problem described in first question is solved.

[MK_QSL]

May be because your both tables two fields are common and creating a synthetic key.

You should either try to rename the Population or Mobile User field or try

CAN HELP YOU better is I have your sample script.