2 Replies Latest reply: May 10, 2017 9:58 AM by Sunny Talwar RSS

    Concatenate number with text for display

    David Pardoe

      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!