topic Re: Concatenate number with text for display in App Development

Concatenate number with text for display

Wed, 10 May 2017 13:07:12 GMT

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 — Wed, 10 May 2017 13:10:58 GMT

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

edit: similar in Chart-Properties

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

sunny_talwar — Wed, 10 May 2017 13:58:56 GMT

You can also try this

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

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