2 Replies Latest reply on Jul 25, 2012 7:03 AM by MarcMcCall

    FMP11 getting currency format right



      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?

        • 1. Re: FMP11 getting currency format right

          The data formatting is working as it should, just not as you want it to.

          Specifying a fixed number of decimals, sets it for all values in that field. Most users would not consider £110.00 to be "undesirable, but rather the expected and preferred result of this formatting option as it allows you to right justify a column made of this field and the numbers then properly align with each other.

          "Do not display number if zero" produces an empty field if the value of the number, not adigit, is zero. If you enter 0 in the field, it will display as empty instead of as 0.00.

          The formatting that you want cannot be achieved with data formatting options. You'd either need to use two copies of the field placed on top of--each with different data formatting options with conditional formatting making one field invisible and the other visible, or you'll need to use a calculation field that takes the value of this field and produces a text result with the desired formatting.

          • 2. Re: FMP11 getting currency format right

            Sounds like you need to remove the fixed # of decimal places, because this is always going to give you 2 decimal places.  The do not display # if Zero will only work if the number is zero. It will not display 0.00