Table of Contents

, , ,

NFORMAT

Description

Formats a number differently depending on its value – whether it is positive, negative or zero. Returns formatted number

Syntax

NFORMAT (number, positive, zero[, negative])

Cannot be used in the condition of a FIND action.

Parameters

expression, such as SUM, format of the positive non-zero value; format of the zero value; optional format of the negative value

Returns

Text: the number formatted with the format that matches its sign (positive, zero or negative).

Example

<<NFORMAT(SUM Object.Attribute, '#.00', '')>> 

AS_STRING, ROUND, SIGN