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 for...
Forum Discussion
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
------------------------------
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
------------------------------
This would be a formula text field?
------------------------------
Del
------------------------------
------------------------------
Del
------------------------------
- Since you want a numeric value, it would be a formula number field
------------------------------
Paul Peterson
------------------------------- Thanks, some modifications but works!
------------------------------
Del
------------------------------
