This content has been marked as final. Show 2 replies
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!