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

[AEM Gems Webinar] Accelerating Experience Manager as a Cloud Service development with Rapid Development Environments
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

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

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

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!