Copy link to clipboard
Copied
Hello,
I'm trying to create a field that will automatically calculate drug compliance on a clinical trial. The formula is:
(Total dispensed - returned) / (Days between visits x dose[# of pills])
Example:(200-120) / (31 x 3) = 80 / 93 = 0.86 x 100 = 86%
I've used the below code in Adobe Acrobat Pro DC:
event.value=(this.getField("Text45").value-this.getField("Text46").value)/(this.getField("Text60").valueXthis.getField("Text48").value)
It accepts it with out any script error flags but the formula isn't working- its not calculating at all. Where did I go wrong?
Christy
Copy link to clipboard
Copied
The multiplication operator in JS is "*", not "X"...
Also, you would need to make sure that the denominator is not zero, or you'll get some strange results, or error messages.
Copy link to clipboard
Copied
Thank you so much. I just spent an hour searching on how to fix this issue!