AnsweredAssumed Answered

FMP11 getting currency format right

Question asked by PeterThorton on Jul 24, 2012
Latest reply on Jul 25, 2012 by MarcMcCall


FMP11 getting currency format right



I have made some reports as part of my FMP solution, with lots of values displayed as currency on them. So far I've been able to achieve pretty much what I need, i.e. 110 pounds is displayed as £110. However, I can't get values like 3 pound 20 to display correctly. It displays as £3.2, while my boss is expecting £3.20 of me. I tried playing around with the data formatting, I've checked "Fixed number of decimals:" and set it to 2. This does change the £3.2 to £3.20, however, it also changes all the other fields - £110 becomes £110.00, and so on. Needless to say, this is undesirable. I tried checking the "Do not display number if zero" option, but it's either broken, or does something else entirely, because it doesn't help with my problem.

What can I do about this?