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

Calculations

Forum Index > Forms: Acrobat > Calculations
2010-08-13 11:55:22
ldiehl
Registered: Aug 13 2010
Posts: 2
Answered

I have several fields that I want to add together, then subtract another field from it and then divide that total by 2. If my addition fields are:

Total Resources
Pell
SEOG
Work Study

And I want to subtract my field titled "Total Expenses".....then divide that total in half, what would my calculation be?

Lynne

My Product Information:
Acrobat Pro 9.3, Windows
Top
2010-08-13 13:27:13
#1
smitchell15 (not verified)
Hi

In the field that you want the calculation to work in. Open up its properties and in the calculate tab, choose simplified field notation, and choose edit, in there type something like this (TotalResources + Pell) - SEOG /2

Change field names accordingly, bet bare in mind, this method only works if your field names have no spaces or special characters like _!@^ etc.

Hope it works for you.

Let me know if ya still struggling :)

Cheers
Top
2010-08-16 13:45:24
#2
ldiehl
Registered: Aug 13 2010
Posts: 2
I could not get the formula to work with MOST of your suggestion. However, I just needed to modify it a little. The formula ended up being (Totalresources+pell-SEOG)/2. The second parenthesis needed to be outside the entire group of totals, but before the division.....not before the "-". Thank you for your help. I was getting really frustrated with this, but you helped me figure it out.

LDiehl
Top
2010-08-18 18:21:23
#3
Outlook123
Registered: Aug 18 2010
Posts: 2
I need a simple division.
When an amount is entered in B it is divided by A and answer shows in C
I am an absolute beginner

Rose

Top
2010-08-19 07:30:19
#4
gkaiseril
Online
Expert
Registered: Feb 23 2006
Posts: 4308
Unless your divisor is always non-zero you can use the '/' for division.

But if the divisor will ever be zero, and that includes on an empty form or reset form, then you have to write a custom script using an 'if' statement to prevent execution of the division when the divisor is zero or null. A null value is treated the same as the numeric value zero.

I have posted an editable calculation script for this. You can search for 'division'.

[url=http://acrobatusers.com/forums/aucbb/viewtopic.php?id=24626]Division[/url]

George Kaiser

Top