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

# Percentage in table

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:

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

• ###### Re: Percentage in table

Did you also put a check nexty to Show in Percent (%)?

I take that back, You are formatting based on the expression, you need to select Expression Default here

UPDATE: Also remove *100 from the expression

Num(Count({<Q11={'OUI','Oui'}>}Q11) / RangeSum(Count({<Q11={'OUI','Oui'}>}Q11), Count({<Q11={'NON','Non'}>}Q11)),'#.##0,0%')

• ###### Re: Percentage in table

try this

num(Count({<Q11={'OUI','Oui'}>}Q11) / rangesum(Count({<Q11={'OUI','Oui'}>}Q11) ,Count({<Q11={'NON','Non'}>}Q11),'#0.00%')

• ###### Re: Percentage in table

Hi,

Can you try as below in the number tab in table properties.

Thanks