AnsweredAssumed Answered

FMP11 getting currency format right

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

Title

FMP11 getting currency format right

Post

Hello,

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?

Outcomes