Basic calculations in LiveCycle

Avatar

Avatar

Maribethlm

Avatar

Maribethlm

Maribethlm

07-04-2011

I'm trying to create basic calculations in a form that I am creating in LiveCycle Designer. Has anyone does this, and can you please give me some help? I don't understand the instructions in the Help feature or the book that I have.  Here is what I am trying to do:

Text Field A 100 (manual entry)

Text Field B 75   (manual entry)

Text Field C 25   (Result of calculation of A - B = C)

Then:

Text Field D 2    (manual entry)

Text Field E 50  (Result of calculation of C X D = E)

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

pguerett

Avatar

pguerett

pguerett

07-04-2011

I prefer to use Javascript so on the Calculate event of the C field you would use this command:

this.rawValue = FieldA.rawValue -Field B.rawValue

Then on E Field's calculate event you woudl use this command:

this.rawValue = FieldC.rawValue * FieldD.rawValue

If you woudl prefer to use FormCalc you woudl still use the Calculate event and on FieldC the command woudl be:

FieldA - FieldB

On the calculate of Field E

FieldC * FieldD

Hope that helps

paul

Answers (10)

Answers (10)

Avatar

Avatar

pguerett

Avatar

pguerett

pguerett

13-04-2011

Works fine for me ...here is a sample ...the code is on the calculate of the total field. Oh ....and make sure your fields are numeric.

Paul

Avatar

Avatar

Maribethlm

Avatar

Maribethlm

Maribethlm

13-04-2011

THANK YOU SO MUCH!!!!!!!  I cannot tell you enough at how much I appreciated your help!  I hope that you have an awesome day!

Avatar

Avatar

pguerett

Avatar

pguerett

pguerett

13-04-2011

Email it to LiveCycle8@gmail.com . Please include a description of the issue.

Paul

Avatar

Avatar

Maribethlm

Avatar

Maribethlm

Maribethlm

13-04-2011

Yes the language is set to javascript.

How can I send you a file that I created with the portion of the form that I cannot get to work?  I've looked for a way to upload to here, but I don't see anything.

Avatar

Avatar

pguerett

Avatar

pguerett

pguerett

13-04-2011

Nope .....did you set the language to javascript?

Paul

Avatar

Avatar

Maribethlm

Avatar

Maribethlm

Maribethlm

13-04-2011

Could it be because I am using LiveCycle Designer 8.0?

Avatar

Avatar

Maribethlm

Avatar

Maribethlm

Maribethlm

13-04-2011

It is not working.  It is no longer giving me any value. Bummer.  Any other ideas?  Could it be because I have the Display Pattern as a with a dollar sign?  I'm thinking not, but hey, just checking.

Avatar

Avatar

pguerett

Avatar

pguerett

pguerett

13-04-2011

There is a native javascript function to get the absolute value of a number .....lets assume your fields are called Field1 and Field2. Then the command woudl be:

Total.rawValue = Math.abs(Field1.rawValue - Field2.rawValue)

Paul

Avatar

Avatar

Maribethlm

Avatar

Maribethlm

Maribethlm

12-04-2011

Okay, Paul, I have another question...  I'm not even sure that it is possible.

Do you know how to force a positive result?  Here is my example of what I am trying to say:

Value A: $1.00 minus Value B $1.10 equals -$0.10 (this comes out to a negative, but I need to just show it as a dollar amount not as a negative)

Not all situations will result in a negative number - so I need to always just show it as a dollar figure regardless of positive or negative.

Avatar

Avatar

Maribethlm

Avatar

Maribethlm

Maribethlm

07-04-2011

Thank you so much!!! That worked!!!