Convert number to decimal

Question

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
------------------------------

paulpeterson1 · Answer

Since you want a numeric value, it would be a formula number field------------------------------Paul Peterson------------------------------

paulpeterson1 · Answer

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 · Answer

This would be a formula text field?------------------------------Del------------------------------

del · Answer

Thanks, some modifications but works!------------------------------Del------------------------------

Forum Discussion

Convert number to decimal