Return Sum of Specific Type
Designed to be used in conjunction with a repeatable section. This example can be used to return the sum of values for a specific variable that is captured in a choice field inside a repeatable section.
In the example code below the cost_field
captures the cost while the item_type_field
is used to capture the type of item that the cost is associated with in a child record. The code then loops through comparing the two arrays and returns a sum of all values in the cost_field
where the item_type_field
is equal to Item A
.
var cost = REPEATABLEVALUES($repeatable_section, 'cost_field');
var items = REPEATABLEVALUES($repeatable_section, 'item_type_field').map(CHOICEVALUE);
var total = 0;
for (var i = 0; i < cost.length; ++i) {
if (items[i] === 'Item A') {
total += NUM(cost[i]);
}
}
SETRESULT(total)
}
Updated about 1 year ago