Skip navigation
Andopwr
Andopwr Calculating status...
Currently Being Moderated

Calculations gone wrong

Jul 31, 2012 10:02 AM

Categories: Macintosh Tags: #calculation #calculated_field

I cannot for the life of me figure this out!  I will satrt with, I am fairly new to this, but I can creat fields and edit them.  However, every time I try and do simple calculation with "the value is"  window i run it and things seem okay until I adjust other fields on the form to calculate as well.  And then the previous fields get messed up.

 

I am wanting in the top portion, "Sub-Total" = ("Rate Per Night" x "Tax")

Then I want "Total" = ("Sub-Total" x "# Of Nights")

Then I want on the bottom:

"Sub-Total" = (90.00+30+30+30+30+30+30+30)

"Tax" = ("Sub-Total" x "Tax")

"Total" = ("Total [from top]"+"Sub-Total [from bottom]+"Tax"+"Svc Fee")

 

I went through the edit properties and calculated them but still they keep getting messed up or not even close.  I know i may come across dumb but I need help.

 

Thank you.

please help me!!!!!


field-screenshot.png

428 Views   7 Replies   Latest reply: George Johnson, Jul 31, 2012 10:50 AM
 
Replies
  • George Johnson
    9,208 posts
    Aug 11, 2002
    Currently Being Moderated
    1. George Johnson,
    Jul 31, 2012 10:10 AM   in reply to Andopwr
    Report

    The first thing you need to do is make sure that the field calculation order is correct. Exactly how you do this depends on which version of Acrobat you have. First go into form editing mode. In Acrobat 9 you'd then select: Forms > Edit Fields > Set Field Calculation Order

     

    In Acrobat 10, select: Other Tasks > Edit Fields > Set Field Calculation Order

     
    |
    Mark as:
  • Andopwr
    Currently Being Moderated
    2. Andopwr,
    Jul 31, 2012 10:27 AM   in reply to George Johnson
    Report

    Okay - I did that.   I am working with Acrobat Pro 9

     
    |
    Mark as:
  • Andopwr
    Currently Being Moderated
    3. Andopwr,
    Jul 31, 2012 10:34 AM   in reply to Andopwr
    Report

    I did the "set field calculation order" and I believe I have them in the right order.  (top to bottom as they occur)  but the problem is the fields change with any additions I make.  Giving me crazy numbers.

     
    |
    Mark as:
  • George Johnson
    9,208 posts
    Aug 11, 2002
    Currently Being Moderated
    4. George Johnson,
    Jul 31, 2012 10:40 AM   in reply to Andopwr
    Report

    Let's start with just one field. How do you have the Tax field that's at the top of the form configured to calculate, exactly?

     
    |
    Mark as:
  • Andopwr
    Currently Being Moderated
    5. Andopwr,
    Jul 31, 2012 10:43 AM   in reply to Andopwr
    Report

    I figured it out I was doing an extra step in percentages.  you da man!!!!

     
    |
    Mark as:
  • Andopwr
    Currently Being Moderated
    6. Andopwr,
    Jul 31, 2012 10:45 AM   in reply to George Johnson
    Report

    It was that tax field at the top!  I just locked in and made it read only so noone can put a number in there.  and as long as you add the correct percentage in the bottm tax field every time it, it should be good.  Is there a way to give that bottom tax field a fixed percentage so it doesnt need to be typed in?

     
    |
    Mark as:
  • George Johnson
    9,208 posts
    Aug 11, 2002
    Currently Being Moderated
    7. George Johnson,
    Jul 31, 2012 10:50 AM   in reply to Andopwr
    Report

    It's not clear to me how it needs to work exactly, but you can set a default value for a field and make it read-only.

     
    |
    Mark as:
Actions

More Like This

  • Retrieving data ...

Bookmarked By (1)

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