Skip navigation
Maribethlm
Maribethlm
Currently Being Moderated

Basic calculations in LiveCycle

Apr 7, 2011 11:28 AM

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)

1946 Views   11 Replies   Latest reply: Maribethlm, Apr 13, 2011 10:51 AM
 
Replies
  • pguerett
    Currently Being Moderated
    1. pguerett,
    Apr 7, 2011 11:44 AM   in reply to Maribethlm
    Report

    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

     
    |
    Mark as:
  • Maribethlm
    Currently Being Moderated
    2. Maribethlm,
    Apr 7, 2011 11:55 AM   in reply to pguerett
    Report

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

     
    |
    Mark as:
  • Maribethlm
    Currently Being Moderated
    3. Maribethlm,
    Apr 12, 2011 8:15 AM   in reply to pguerett
    Report

    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.

     
    |
    Mark as:
  • pguerett
    Currently Being Moderated
    4. pguerett,
    Apr 13, 2011 4:25 AM   in reply to Maribethlm
    Report

    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

     
    |
    Mark as:
  • Maribethlm
    Currently Being Moderated
    5. Maribethlm,
    Apr 13, 2011 7:59 AM   in reply to pguerett
    Report

    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.

     
    |
    Mark as:
  • pguerett
    Currently Being Moderated
    6. pguerett,
    Apr 13, 2011 9:19 AM   in reply to Maribethlm
    Report

    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

    Attachments:
     
    |
    Mark as:
  • Maribethlm
    Currently Being Moderated
    7. Maribethlm,
    Apr 13, 2011 9:27 AM   in reply to pguerett
    Report

    Could it be because I am using LiveCycle Designer 8.0?

     
    |
    Mark as:
  • pguerett
    Currently Being Moderated
    8. pguerett,
    Apr 13, 2011 9:40 AM   in reply to Maribethlm
    Report

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

     

    Paul

     
    |
    Mark as:
  • Maribethlm
    Currently Being Moderated
    9. Maribethlm,
    Apr 13, 2011 9:55 AM   in reply to pguerett
    Report

    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.

     
    |
    Mark as:
  • pguerett
    Currently Being Moderated
    10. pguerett,
    Apr 13, 2011 10:03 AM   in reply to Maribethlm
    Report

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

     

    Paul

     
    |
    Mark as:
  • Maribethlm
    Currently Being Moderated
    11. Maribethlm,
    Apr 13, 2011 10:51 AM   in reply to Maribethlm
    Report

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

     
    |
    Mark as:
Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points