1 Reply Latest reply on Jan 11, 2013 5:13 PM by philmodjunk

    Number formatting for different countries

    med

      Title

      Number formatting for different countries

      Post

           I recently deployed a solution in an office in Japan and discoverd that their currency has no fractions. Therefore I need to format all currency fields (in entry layouts and reports) to have 2 decimal places for USA but none for Japan.

           It would be an ugly solution to duplicate hundreds of layouts for that purpose.

           I am using filemaker pro 12

           Any smart ideas ?

        • 1. Re: Number formatting for different countries
          philmodjunk

               Perhaps you can use the Round function in an auto-enter calculation that checks a global preferences field to determine whether to round values to 2 or 0 decimal places? and the same expression can include a calc that adds any needed trailing zeroes after the decimal place. The global field (or a global variable) can be loaded from a preferences table when the file opens.

               But use it for display. Rounding values at the wrong tims can introduce small cumulative errors into your data if the rounded values are used in calculations where unrounded values should be used instead.