Sum in subtotal using array not working

Asked Jul 17 '18 at 18:08

Active Jul 17 '18 at 18:40

Viewed 25 times

I am using the following code and the result isn't the actual sum of the values, but returns the values in order: $1.00, $2.00, $3.00 shows 123.00, not the expected $6.00

var oFldSub = this.getField("Sub");
if(oFldSub != null)
{
   var  aLineSub = oFldSub.getArray();
   var sum = 0;
   for(var i=0;i<aLineSub;i++)
   {
       if(!isNaN(aLineSub[i].value))
          sum += aLineSub[i].value;
   }
   event.value = sum;
}
else
   app.alert("Form Error");

edited Jul 17 '18 at 18:40

j08691

204,283
31
260
272

asked Jul 17 '18 at 18:08

AngelJS

Your snippet may give you the answer: `"message": "Uncaught TypeError: this.getField is not a function",` – Michael Jul 17 '18 at 18:11
i guess that `aLineSub[i].value` return string, so try convert it to int: `parseInt(aLineSub[i].value)` – RainDev Jul 17 '18 at 18:12
Rainmx93 that didn't work. I get a Syntax Error: invalid label – AngelJS Jul 17 '18 at 18:22
Michael, I saw the error, but do not know how to fix. – AngelJS Jul 17 '18 at 18:23
then try: `parseFloat(aLineSub[i].value)` – RainDev Jul 17 '18 at 18:28
parseFloat gives me a result of 0. – AngelJS Jul 17 '18 at 18:32
do this `sum += +aLineSub[i].value;` – Emeeus Jul 17 '18 at 18:42
sum += +aLineSub[i].value; is the line that I have already. If this.getField is not a function, then I am not sure what to try next. I copied this code from a forum that had a similar situation that I am dealing with, but it doesn't work. – AngelJS Jul 18 '18 at 13:17

Sum in subtotal using array not working

0 Answers0