I have some fields that perform a basic average calculation. The fields are using number formatting, and they are using decimal formatting. My fixed number of decimal digits is 1 because if I set it at 2, I don't get clean percentages. I'm using percent notation with no thousands separator.

My question is regarding the rare ocassion when the average is actually 1. (The numerator and denominator are the same.) This causes a "?" to appear, but when you click in the field, it says "1". I can't get it to show as "100.0%" Any ideas? Thanks a mil!

Try making the field wide enough to accommodate the entire string "100%".

Thanks for your reply. That was one of the first things I tried before I entered this post, but that's not actually the problem. The problem has to do with the fact that the calculation, in this rare instance, produces a whole number instead of a decimal. So the decimal formatting and percent notation doesn't know what to do with it.

The percent notation works perfectly fine with whole numbers. Getting a result of "100%" or "214%" or "-0.2%" is hardly a rare instance - it happens every day.

You are so right. I had expanded the field earlier, but apparently I didn't expand it enough. I just stretched it out further, and that was the answer. Thank you!