I have three text box that are set as currency as the format , default value ( blank). I would like to add the totals together. I tried the following but if the text box is blank then nothing is added but if I put 0 in the text box it works but I do not want anything showing in the field if there is no amount
i tired.
=[price]+[price1]+[price2]
as long as there is a amount in each field it works but if one is blank it doesnt