These forums are now Read Only. If you have an Acrobat question, ask questions and get help from one of our experts.

Error for FormCalc

2008-06-03 13:41:53

sinc

Registered: Jun 3 2008

Posts: 19

Answered

Have an entry cell for noi and one for cap_rate. The result cell is:

noi / cap_rate * 100

Works fine except that entering a number in the noi cell generates a "Script failed" with "Error: arithmetic over/underflow". A click on the OK button enables one to proceed with the calculation, but that's not acceptable. How do I eliminate this error message?

Thanks.

Joseph T. Sinclair
Publisher
RealEstateInvestmentCenter.com

2008-06-03 14:34:43

gkaiseril

Registered: Feb 23 2006

Posts: 4308

How do you divide by zero?

if(HasValue(cap_rate) then
noi / cap_rate * 100
else
''
endif

George Kaiser

2008-06-03 16:13:53

sinc

Registered: Jun 3 2008

Posts: 19

Well, the natural order would be to enter the NOI first and then the cap rate. But reversing the entry order would solve the problem, although it wouldn't seem as natural to users.

I will experiment with your script to see what I can do.

Thanks.

Joseph T. Sinclair
Publisher
RealEstateInvestmentCenter.com

2008-06-04 06:44:40

sinc

Registered: Jun 3 2008

Posts: 19

The script works. Thanks.

Joseph T. Sinclair
Publisher
RealEstateInvestmentCenter.com