Calculate additional text fields

Question

I'm using the following custom calculation script in a text field named 'TotalOTHrs' and it works great. However, I also need to calculate the hours from another 35 dropdowns name 'MBHrs1' to 'MBHrs35. I'm strugging with how to input that and I could sure use some much appreciated help. Thanks.

var maxFields = 35; //
var total = 0;
for (var i=1; i<=maxFields; i++) {
if (this.getField("OTPayType"+i).valueAsString!="CDO Banked")
total+=Number(this.getField("OTHrs"+i).valueAsString);
}
event.value = total;

Nesa Nurani · Accepted Answer

So if value from dropdown is not "CDO Banked" you want to calculate both "OTHrs" and "MBHrs"?

I ask because in your two posts you used different condition in first you use != "CDO Banked" and in second == "CDO Banked", so which one is it?

If OTHrs and MBHrs are in the same row for each dropdown, you can just sum them, like this:

total+=Number(this.getField("OTHrs"+i).valueAsString)+Number(this.getField("MBHrs"+i).valueAsString);

traceyc28668387 · Answer

I definitely need help with the script above so the total hours can calculate from both OTHrs and MBHrs into the text field 'TotalOTHrs', except when the user selects 'CDO Banked' from the OT PayType dropdown. Please help.

Note: I also have another text field named 'CDOBankedHrs' with the following custom calculation script, which is good.

var total = 0; for (var i=1; i<=35; i++) { if (this.getField("OTPayType"+i).valueAsString=="CDO Banked") total+=Number(this.getField("OTHrs"+i).valueAsString); } event.value = total;

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