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

Lease agreement Prorate calculation

2011-11-14 21:02:59

emma1440

Registered: Nov 14 2011

Posts: 1

Hi Guys,

My boss has asked me to convert our lease agreement into a fillable PDF and also put custom formulas in there for the lease agreement to automatically calculate the prorated amount of the rent depending on when the tenant moves in. I have tried different java scripts but I have not had any luck. Would someone please help me. I have the formula in excel as follows days in unit =D10-D6+1, daily rate =D4/(D10-D8+1), and the total rent due =D14*D12. Please help me with a calculation.

Emma

My Product Information:
Acrobat Pro 9.0, Windows

2011-11-15 02:15:48

try67

Registered: Oct 30 2008

Posts: 2398

If you've given your fields simple names, without any spaces or other special characters then you can use the "Simplified field notation" option in the Calculate tab, and simply write out the formulas using the fields' names. The only problem might be with calculation of the daily rate, if the denominator is 0 (which is not allowed).
See this tutorial as well: http://acrobatusers.com/tutorials/2006/form_calculations

- AcrobatUsers Community Expert - Contact me personally at try6767 [at] gmail [dot] com
Check out my custom-made scripts website: http://try67.blogspot.com

2011-11-15 07:47:25

gkaiseril

Registered: Feb 23 2006

Posts: 4307

You may need to provide more detailed information about the data you are processing.

See:
Working with date and time in Acrobat JavaScript (Part 1 of 3) by Thom Parker
Working with date and time in Acrobat JavaScript (part 2 of 3) by Thom Parker
Conditional Execution by Thom Parker

George Kaiser