Forum Discussion

Del's avatar
Del
Qrew Cadet
3 years ago

Convert number to decimal

Looking to have a field on a form that can accept an entered fraction 1/8,  a percent entered as 25%, Decimal .05 or an integer and have it display as a decimal in any case. Do I create a separate formula field?

------------------------------
Del
------------------------------
Formulas and functions

4 Replies

Sort By
  • PaulPeterson1's avatar
    PaulPeterson1
    Qrew Assistant Captain
    3 years ago
    Here's the happy case where you don't have multiple slashes, a % at the beginning of the text or a combination of slashes and percent signs:

    var number loc = Find([Number Text], "/");

    If(Right([Number Text],1) = "%",ToNumber([Number Text]) / 100,
    $loc > 0, (ToNumber(Left([Number Text], $loc - 1))) / (ToNumber(Right([Number Text], "/"))),
    ToNumber([Number Text]))

    ------------------------------
    Paul Peterson
    ------------------------------
    • Del's avatar
      Del
      Qrew Cadet
      3 years ago
      This would be a formula text field?

      ------------------------------
      Del
      ------------------------------
      • PaulPeterson1's avatar
        PaulPeterson1
        Qrew Assistant Captain
        3 years ago
        Since you want a numeric value, it would be a formula number field

        ------------------------------
        Paul Peterson
        ------------------------------