Format a field right padding
I have a field that I have formatted with a number (amount) and unit. I am right padding the field to get it to line up the numbers. If I right pad with SPACES it does not work. If I right pad with a character, period or dash, it works. I have posted two examples and the calculation.