Functions (all)

FormatFloat

Function Name:
FormatFloat
Description:

This function converts a floating point number to a text string.  It takes three parameters: the floating point number, and two additional numbers that specify how to handle decimal points.

Minimum FH Version:
7.0
No. of Parameters:
3
Return Type:
Text
Parameter 1:
Float.  The floating-point number to format.
Parameter 2:
Number. Normal precision.  With numbers that do not display as zero, this is the maximum number of digits to show after the decimal point (using rounding).  So if the floating point number was 354.4573 and normal precision was 2, the number would be displayed as "354.46".  Trailing zeros are removed.
Parameter 3:
Number.  Special precision. This value is only relevant if the floating-point number would display as "0" using normal precision.  In that case, the smallest precision value that is less than or equal to the special precision value, and which results in anything other than "0", will be used.  Specifying a special precision value that is less than or equal to the normal precision value, has no effect.
Examples:

=FormatFloat(DnaRelatedness(%CUR_DGM_ROOT%,%INDI%),2,8)