Within skybow rich forms there is a function to easily calculate (sum / average / count / min / max) of sublist numbers.

This is taking the value of every row whatever the value is.

But if you want to calculate (e.g. the sum only of numbers bigger than 12), you can use the following function code and loop through the sublist items:

`var total = 0;`

var arr = [[@SubLists.Sublist.Number]];

for(var i in arr) {

var number = parseFloat(arr[i].replace(",",""));

if(number > 12) {

total += number;

}

}

return total;

Cheers

Matthias

## Comments

0 comments

Please sign in to leave a comment.