Null if zero

Here's a script that is created on a "total" field. If quantity is not equal to zero (in other words some data is in the field) then the quantity is multiplied by the price (a fixed vailue). If quantitly is equal to 0 (else...) then the last line of code removes the default zero.

var f = this.getField("quantity");
var g = this.getField("price");

if (f.value != 0)
event.value = f.value * g.value
else
event.value =""

Hope this helps.

—ted

None of that makes sense to me. I just don't want the zero's to show! I don't need it to do any fancy stuff, I just want the field to be blank if no data is entered anywhere on the form. I don't understand why this is so hard. I have asked this same question about six different ways and I have gotten six different answers - none of which work. Please, oh please just make the zero's go away!

I see where you're coming from. I'm looking into doing the same simple task and having trouble. In my case I have three fields; rate, hours and total. On the total filed I have a simple (rate * hours) script. It defaults to a $0.00 value when nothing is entered into rate and hours. How do you make this go away? If there is no value in rate or hours I just want the total to be "blank". Can this be done? Thanks.

Basically, you use the script I suggested in the previous post. Just open the field Properties dialog box, click the Calculate button and add a JavaScript using the same code as above but substitute my Quantity for your rate and my Item for your hours.

ted