Newbee: Displaying Percentage Correctly within crosstab

[Former Member]

I'm sure I'm missing something obvious, but I have a cross tab that is displaying percentage results as: 1.0000%

Obviously what I want is for it to be displayed as 100%...the results are correct, but the decimal is in the wrong place (actually I don't even want it to be displayed, just 100%).

Any help would be appreciated.

[Former Member · Accepted solution]

Hi Gary,

Is this a database field or are you calculating the percentage in a formula?

If it is a dabase field, please check if it show 100% there.

If it is a caluclated field then multiply the result by 100 and go to the format field option (in the right click menu for that field) and there you will be able to specify the format in which you want to see the values.

Please let us know if this helps.

Cheers!