Hide Zero Values

I assume that you are speaking of the Purchase Order sample. The 0 is showing up because you have a calculation on that field.



On the validation pattern (Edit), there is a checkbox that says allow empty. This in turn is firing the calc for the amount field and making it empty as well.

Paul,



Thanks for the quick response, I'm not so sure that we are talking about the same program as I do not have that choice when the field is selected. I am referring to the "Invoice Template" found when setting up a form from the "File" "New". When I select the field my only options under OBJECT are "Field, Value, Binding". Under the "Edit" menu at the top of the screen I do not have a "Validation pattern" This choice is availabe but grayed out on the "Object", "Value" menu due to the field being Calculated Read Only.



Thanks again in advance.

You can get to the validation patterns from the Object/Field palette.

Ermm... may I help?



Do the calculation with Javascript in the amount field:

if (Quantity.rawValue != null && UnitPrice.rawValue != null)

{this.rawValue = Quantity.rawValue * UnitPrice.rawValue}



Hope that helped

Lisa



Edit:

Equivalent for the total Amount:

if (Amount1.rawValue == null && Amount2.rawValue == null ...)

{this.rawValue = null;}

else

{this.rawValue = Amount1.rawValue + Amount2.rawValue ....;}