Add only negative numbers in a set of data

Question

I have an expense report that has fields for "New Charges" and "Credits". Each of these comes from a set of data listed as "Amount.x". (Think a long row of charges named Amount.1, Amount.2... so on).

I want "New Charges" to be the sum of numbers greater than or equal to 0, and "Credits" to be the sum of anything less than 0. How do I write a script for these?

Nesa Nurani · Answer

Try this, just replace 4 with the number of "Amount" fields you have:

var charges = 0;
var credits = 0;

for(var i=1; i<=4; i++){
 var f = Number(this.getField("Amount."+i).valueAsString);
  if(f > 0)
   charges += f;
  if(f < 0)
   credits += f;}

this.getField("New Charges").value = charges;
this.getField("Credits").value = credits;

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.