Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Basic calculations in LiveCycle

Avatar

Not applicable

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)

1 Accepted Solution

Avatar

Correct answer by
Level 10

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

View solution in original post

0 Replies

Avatar

Correct answer by
Level 10

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

Avatar

Not applicable

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

Avatar

Not applicable

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

Level 10

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

Not applicable

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

Level 10

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

Not applicable

Could it be because I am using LiveCycle Designer 8.0?

Avatar

Level 10

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

Paul

Avatar

Not applicable

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

Level 10

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

Paul

Avatar

Not applicable

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