Copy link to clipboard
Copied
I'm having difficulty having the calculations in the following order to calculate automatically. However, I'm getting the results I need for only 1 row instead of all 3.
For example I want the value of 100 to multiply by 66% (which is CORRECTLY calculating in the 2nd row)
But then when I want the value of 100 to multiply by 8% (but the results arn't calculating correctly and giving me the results of the 2nd row). Same applies for wanting the value of 100 to multiply by 7%.
(CALCULATION SCREENSHOTS BELOW!)
Can anyone help?!
I can't see any values in your % fields. You don't need those fields from what I can see. Use a custom calculation script in the x fields:
event.value=this.getField("undefined").value * .66;// for x66
event.value=this.getField("undefined").value * .08;// for x8
event.value=this.getField("undefined").value * .07;// fro x7
You really should choose better names for your fields, avoiding non-alpha numeric characters like % and non-descriptive terms like "undefined" to avoid confusion.
Copy link to clipboard
Copied
I can't see any values in your % fields. You don't need those fields from what I can see. Use a custom calculation script in the x fields:
event.value=this.getField("undefined").value * .66;// for x66
event.value=this.getField("undefined").value * .08;// for x8
event.value=this.getField("undefined").value * .07;// fro x7
You really should choose better names for your fields, avoiding non-alpha numeric characters like % and non-descriptive terms like "undefined" to avoid confusion.
Copy link to clipboard
Copied
THANK YOU!
It worked!!
However, for some reason only the 7% section keeps giving me this result.
I've tried deleting the text field and creating a new one. And the results are still the same.
Any idea why?
Copy link to clipboard
Copied
Nevermind. I figured it out.
Thanks for all your help!