AnsweredAssumed Answered

Mixed number formatting in calculation

Question asked by vmtc on Aug 16, 2010
Latest reply on Aug 16, 2010 by vmtc


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,

No Sales.

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