zeroblank(
zeroblank(
VALUE
)

The zeroblank( function tells Panorama to treat zeroes as empty space.

Parameters

This function has one parameter:

value – is any numeric value or formula. If any field in this value or formula is blank (empty), the result of the formula will be blank (empty).

Description

This example calculates a line item in an invoice. The amount is calculated by multiplying the quantity times the price. However, if either the quantity or the price is blank (not zero, but actually blank) the amount will also be blank. This avoids the cluttered look in your invoices.

    Amount = zeroblank(Quantity * Price)

See Also

- sizeof( -- calculates the amount of memory used by a field or a variable.

History

Version | Status | Notes
10.0 | No Change | Carried over from Panorama 6.0