sum help. Multiply cell b + c + d * 200000 / a

[dbjackie]

This formula is driving me crazy. Its a 3 step process. For one cell.

I need to add cell  b + c + d

Then take that number and times by 200,000

then take that number and divide by a

Does anyone have an idea?

[dbjackie]

[radzmar]

In FormCalc it should look like:

[dbjackie]

im getting a wierd error...

[dbjackie]

if a number is already present in A i dont get an error..

i get this error testing in preview in live cycle...

Is there a way to prevent this??

[radzmar]

This error appears, because one of your values is 0.

A division with 0 returns always 0 and the script fails.

So, to avoid the error, you can wrap you formula into an if expression.

[dbjackie]

now im getting this error.. We are getting so close to fixing this, i can feel it

Code Behind

[dbjackie]

on a side note.. After i hit ok, the calculations work and act right.. I just get this screen when i try to open the form

[radzmar]

Is any value null, 0 or negative by default in your form you use for the formula?

[dbjackie]

Its just a numeric field.. Nothing is in the field for value..

[dbjackie]

would it help to upload the live form?? How do I upload the form?

[radzmar]

You can use Acrobat.com or any other file hoster to share your form.

[dbjackie]

heres the link

https://acrobat.com/#d=ynvmL4470ePd6FUSZReVCQ

[radzmar]

Ok,

that was what I'm asking for.

If any of the values (a1 to e1) is null (empty) the script fails.

So, you need a more specific expression for you formula.

In TIR1 add:

and in LTA1 add:

[dbjackie]

I will give that a spin ty

[dbjackie]

the errors are gone but now the form is not calculating...... ugh.... this is driving me crazy.. Why??

https://acrobat.com/#d=eOTZq0SBO8g1AxeGxEQF8A

[radzmar]

Hmmm...I don't see a problem in your form.

The calculations works, when the fields a - e are filled with a value.

[dbjackie]

The TIR and LTA Fields are not working

[BarlaeDC]

Hi,

When I download and open your form I get an error on the LTA1 layout ready event, because "Round" is not defined, This is due the script being set to be JavaScript but it is actually FormCalc.

If you go to that event and change the script type to FormCalc, it works as I would expect for me in Acrobat X.

Hope this helps.

Malcolm

[radzmar]

For me they do.

I'm not sure what's might be the reason it doesn't work for you.

[dbjackie]

WTF??? Ugh...

Thanks Barlae, i will look into that.