Simple Multiply Fields adding additional calculations.

Question

I have 11 fields that are setup to multiply from field a, to field b. This is a very basic calculation (Dropdowna, hrs1), (Dropdownb, hrs2) and so on. They calculate just fine with inputting data, but when data is changed or added to any other part of the form, the amounts are somehow added to these very basic calculations as a new total and they seem to continue to multiply, producing incorrect results. Any ideas? I'm having major issues here with what should be a very simple task. Calculations are shown in the "Services Needed" columns in the attached image. Thanks in advance!

Rich Valentine

try67 · Accepted Answer

Yes. It is a dropdown which is selected, and then multiplied by another value (hrs multiplied by service requested). What am I missing?

It doesn't make sense. Each time the calculation takes place (which happens each time any field in the file is changed) it will become exponentially bigger.

Your formula is basically: X = X * Y

So if at first X is 1 and Y is 2 the result is 2, but then it will be 4 (2 * 2), 8 (4 * 2), 16 (8 * 2), etc.

You can't include the value of a field in its own calculation. That's circular logic.

try67 · Answer

How did you set up the calculations? Did you use a script? If so, post your code. If not, please describe what you did.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded