The zeroblank( function tells Panorama to treat zeroes as empty space.
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).
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)
|10.0||No Change||Carried over from Panorama 6.0|