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


History

VersionStatusNotes
10.0No ChangeCarried over from Panorama 6.0