Copy link to clipboard
Copied
Good afternoon,
I am trying to create a calculation script that when a number is exceeded in one cell, the number will be muliplied by a percentage and appear in another cell. For example if our total cash cell exceeds $20,000, the total will be multiplied by .40% and the total will appear in another cell. I would really appreciate any assistance from experts.
Thank you.
Copy link to clipboard
Copied
Use something like this as custom calculation script of a field where you want to show result:
var total = Number(this.getField("Total").valueAsString);
event.value = total > 20000 ? total*.40 : "";
Find more inspiration, events, and resources on the new Adobe Community
Explore Now