Mixed number formatting in calculation
I'm trying to create a calculated field that gives a statement involving three sets of numbers, but I can't find a way to format it properly. The specific problem is with a dollar figure which I want to display with two decimal places. However, if the last digit, or last two digits are O, it drops off. So instead of $45.70, I get $45.7
The sentence should read something like either
4 sales. Royalty of 10% on $25.50
Or, if it's the case,
Is there any way I can structure this statement so that it always displays with two decimal places and a $ sign, without affecting the other figures? Rounding doesn't stop it dropping off.
The best I can think of is to do it as a merge field and put the $ and % symbols in manually, and format it, but then I'll get 4.00 sales and 10.00%. Also, this only works properly when there are sales.
I'm using FM Pro 11 Advanced on Mac OSX (DB also used on Windows XP, Vista and 7)
Thanks for your advice