Formcalc to divide

The "Mod" function return the "Modulos" or remainder for a division of the passed value by the passed divisor. The "/' is the divide operator for FormCalc and JavaScript in LiveCycle Designer.

Thank you for the information. I have used the "/" symbol in my calculation and now i am getting the error: arithmetic over/underflow.

Thanky ou for the information. Now I need to figure out what I am missing.

You can not divide by null or zero.

Thanks you. When I skipped over the error message and put a second value in, the calculation worked. How do I keep it from trying to calculate until I out that second value in?

I really appreciate your help.

Use the "HasValue()" function in an "if ...then ...else ..endif" statement.

if(HasValue(divisor)) then
dividend / divisor
else
null
endif

How can i do this with multiple fields. Say i have three fields. One is X and is the dividend and one is Y and that is the divisor and Z is the field that i am placing the result. All the fields are numeric and i want to write a function so that:

if(HasValue(XField) && (HasValue(YField))then
var rent = Xfield.rawValue;
var sqft = Yfield.rawValue;
ZField.rawValue = rent / sqft;
else
Zfield = "0"



For the life of me this should work but i can't get it to check both X and Y for values?????

Justin

I am using livecycle designer 8.0. I'm not sure if that is relevant for the js or not

Hi Justin,

your script has some faults.
You forgot the terminate the if expression with "endif".
And the operator for a logical AND is not "&&", it's only "&" or "and".
You used 2 different spelling for the field "Zfield" - "ZField", so the script is adressed to two different fields.

I made some corrections. The code can be placed directly into the ZField calculate:event.

Ok......I am actually writing javascript and && is the "and" operator so I can't use "&" or "and" from what I have ever coded. The only reason I wrote it like that is I couldn't post the actual code as I hadn't posted enough times to use script apparently. I have hit number 10 now so I am posting the actual code I am using. Here is the actual code I am using in javascript:function figurePSF(){

if(HasValue(NumericField13) & (HasValue(NumericField27)){var rent = NumericField13.rawValue;
var sqft = NumericField27.rawValue;
NumericField28.rawValue = rent / sqft;
}else{
NumericField28.rawValue = "0";
}
}
}


I keep getting an invalid token error so I'm wondering if HasValue is a valid property in javascript or if this is acrobat specific and I have to use the calculate event and if so where is the calculate event for the ZField we'll say. Also, the Z field is just made up and that isn't my actual code it was just an example depicting what I am trying to do.


Justin

Ok I get it................LOL.........I haven't been using the IDE inside acrobat............now that i am using the IDE much much much easier to code. I thought, cause i wasn't thinking, you had to use javascript to do calculations inside the livecycle environment :-)


Thank you for all of your help and patience.

Justin