Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
you may simple use the formatting in Document -> Properties -> Number
edit: similar in Chart-Properties
Else use NUM(MyNumber, '#0.00%')
You can also try this
Text(100*Avg(A_CON_DS_P_STAR)&'%')
or
Num(Avg(A_CON_DS_P_STAR), '#%')