Percentage in table

[#1]

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:

Question	Answer
Q14	10,0
Q11	90,2%
Q13	5.0
Q12	7.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

[sunny_talwar · Accepted solution]

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%')

[Kushal_Chawda]

try this

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

[arasantorule]

Hi,

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

Thanks

[#5]

Thanks for your help Sunny.

Kind Regards,

Hasvine