show as a %

[#1]

Hi,

The following format for an expression in a chart works 99% of the time works to show figures in %.

However, for some reason this won't work:

([Q17. Was the property clean and free from rubbish])/Count(TOTAL[Q17. Was the property clean and free from rubbish])

Any ideas?

Chris

[morganaaron]

Hi Chris,

What format does your field Q17 take?

[#3]

Hi,

Apologies...format?

Data comes from an excel spreadsheet. This question is one of the colum headers.

Chris

[its_anandrjs · Accepted solution]

Try this

Count ( [Q17. Was the property clean and free from rubbish] )

/

Count( TOTAL [Q17. Was the property clean and free from rubbish] )

Regards,

Anand