Never mind.  Danged Endif was missing.

Please have mercy on me and my headache!I'm tripping over my own feet at this point.  All I'm trying to do is a simple if..then..else function and getting no where.  Here's what I've put in:if(ProjectedADC>RehabBeds)then((RehabBeds-ADC)*400000)else((ProjectedADC-ADC)*400000)I've checked and I have F...

Thank you!Moments before I received your solution I realized that in my test file they were all on the same page, but in the work file they were never on the same page --- but I had no idea how to resolve it or prove it was the source of the problem.  I thought because the Global binding worked acro...

I've sent the file.  Thanks for checking it out.

This is incredibly frustrating.  Most of the discussions here are about situations much more complicated that what I'm dealing with.  This isn't an attempt to link to another database, simply to concatenate lastname, firstname middle name.  It functions perfectly in a new file that only contains tho...

I've beat this to death but can't resolve an "accessor" error I'm encountering when trying to concatenate names on the top of pages following the front page on a form.  I've tested it in a separate file file where only the 3 fields and the concatenated field exist and it works perfectly, but when I ...

Can't help you with your primary question, but try using another If level to test for 0 to alleviate the overflow error.Something like:if (HHresp>0) then ......the rest of what you already have followed by another endif.The overflow is being created by your denominator being equal to 0/null before H...

Your error message indicates your script is being executed as FormCalc, not JavaScript.If you're using FormCalc try using an If statment to test for zero/null.if (tr>0) then (ac/tr)*100 endif

The error message is coming from your denominator being initially undefined until a value is posted to NumericField2.The way around it is (in FormCalc):if (NumericField2>0) then (NumericField7/NumericField2)*100 endifThis tells it to only execute the forumla when NumericField isn't 0 or null.