4 Replies Latest reply: May 3, 2016 7:32 AM by Hasvine Dhurmea RSS

    Percentage in table

    Hasvine Dhurmea

      Hello All,

       

      I am trying to show the percentage in my expression but it doesnt seem to work.

      I must use the expression to show the percentage as I do have lines in my tables which does not need to show percentage sign.

       

      Example of my table:

       

      QuestionAnswer
      Q1410,0
      Q1190,2%
      Q135.0
      Q127.0%

       

       

      Below is my expression for Question A :

       

      num(Count({<Q11={'OUI','Oui'}>}Q11) / (Count({<Q11={'OUI','Oui'}>}Q11) + Count({<Q11={'NON','Non'}>}Q11))*100,'#.##0,00%')

       

      In the number tab, I assigned it to Fix, 1 decimal place.

       

      Any idea?

       

      Many thanks,

       

      Hasvine