NUM2FRACTION

Returns a decimal number as a fraction (string format).

Reporting Area(s)

General

Required Parameters

1. Number or numeric field (i.e. .0166666 or coceus)

Optional Parameters

2. Precision of fraction. Default is .000001.

Example(s)

num2Fraction(coceus) returns course CEU value as a fraction (e.g. 1 1/2)

num2Fraction(0.333333,.000001) returns 1/3

num2Fraction(0.333333,.0000001) returns 256410/769231

num2Fraction(0.333333,.00000001) returns 323625/970876

Related Functions

NUM2STR
NUMNODEC
STR
TRANSFORM
VAL