3 Replies Latest reply on Nov 11, 2011 9:18 AM by RossanoIennarelli

    Using Decimal Number

    RossanoIennarelli

      Title

      Using Decimal Number

      Post

      Hi all,

      is a way to use "." instead "," for decimal numbers?

      I use some number field to insert some prices, and a number field to automatic insert the sum

       

      Thanks in advance

        • 1. Re: Using Decimal Number
          philmodjunk

          In layout mode, select the field and then specify its format on the Data Formatting section of the Inspector's data tab. If you specify currency for the data format, you'll see a box appear where you can specify what decimal separator to use for this field.

          • 2. Re: Using Decimal Number
            LaRetta_1

            It depends upon why you want this - I am not clear to the reason.

            If it is just display, then you can set the decimal to comma on the layout (Inspector > Data > Data Formatting at the bottom and then down under Separators.

            If this should affect the data itself then you will need to handle it at the OS level.  To change an existing file, you will need to create an empty clone on the system with the OS set to comma instead of decimal.  Then you would need to import your data into it.

            • 3. Re: Using Decimal Number
              RossanoIennarelli

              it'n not only a layout problem, the number need for a paypal transaction.

              I solved the problem with a script : 

              1. $1 = lenght(number)

              2. $int = int(number)

              3. $2 = lenght($int)

              4. $3= $1 - $2

              5. if $3 = 0 -> $dec = 00

                  if $3 = 2 -> $dec = right (number,1)

                  if $3 = 3 -> $dec = right (number,2)

              6. $correctnumber = $int & "." & $dec

              strange but works!!