Concatenate number with text for display

[#1]

I am trying to show a number as a % value.

In the database it is held (or calculated) as number between 0 and 1.

If I use the expression: 'X'&100*Avg(A_CON_DS_P_STAR)&'%'

I get the right thing (eg. 29%) just with an X at the start.

If I replace the expression with: 100*Avg(A_CON_DS_P_STAR)&'%'

I get the number 0.29

????

I want the first one without the X at the start!

[prieper]

you may simple use the formatting in Document -> Properties -> Number

edit: similar in Chart-Properties

Else use NUM(MyNumber, '#0.00%')

[sunny_talwar]

You can also try this

Text(100*Avg(A_CON_DS_P_STAR)&'%')

or

Num(Avg(A_CON_DS_P_STAR), '#%')