I have a numeric field that does a calculation if (hasvalue) another field..which makes this numeric field show 0. I also have a validation that the input of this field must be 40-140. So when opening it shows 0 and the error message pops up. Is there anyway to have it not show 0 when the pdf opens so the validation script doesn't show an error?
I am guessing that because the script is in the caculation event and there is no data in the other field, it is showing a zero.
You could try an IF statement in the calculation event, which first checks if the other field is null. If it is then it would set the current field to null as well. If the other field hasValue then the calculation would be processed.