I need to display a field that does a variance calculation between 2 percentages as a whole number.
For example, Say control 1 = 55.0% and control 2 = 53.5%, the variance (in the box I am attempting to format) is 1.5%. Is there any way to custom format this variance box to show 150, instead of 1.5% ? Some of my percent variances are very small, and would like to show the basis point change, so I need to display this as the whole number. I have seen the format of #,##0, to scale down numbers, but I need to scale up this number. Any ideas?
Thank you for any help!