zbpattern(
NUMBER
,
PATTERN
)

The zbpattern( function converts a number to text using a pattern, but returns empty text if the number is zero.


Parameters

This function has two parameters:

number – the number to convert.

pattern – the pattern to be used to convert the number to text. See Numeric Patterns for more information.


Description

This function converts a number to text using a pattern. Unlike the normal pattern( function, the zbpattern( function will output "" if the number is zero. (Note: zb is short for zeroblank.)

zbpattern(1234,"#,.##") ☞ 1,234.00
zbpattern(0,"#,.##") ☞ 

Note: This function is equivalent to:

?(thenum=0,"",pattern(thenum,thepat))

See Also


History

VersionStatusNotes
10.0No ChangeCarried over from Panorama 6.0.