NFORMAT

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

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

Cannot be used in the condition of a FIND action.

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

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

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