How to SUM a field in repeat by conditional selected field?
Need to total the volumes reported in the repeater by product in "insumo" field.
In the same form I can have in the repeater several inclusions of the limestone product (named "insumo"), in addition to the inclusion of other products such as phosphate. I need to total each at the end, but I am unable to persist the sum of each product in its respective note. Similar logic to excel sumif.
If I understand the problem here, each record in the repeat as a quantity attribute and a category. The goal is to do a sum of the quantities for each of the categories, as shown in the animation below:
I do not think the sum function is going to help. This is because the sum function sums values for ALL records in the repeat. We cannot tell the sum function to ignore certain records from the repeat.
An alternative approach is to use a custom JS function. I created the animation above with the attached XLSForm and JS Function.
function totalFruit (fruits, quantities, fruit)
{
var fruits_array = fruits.split(',');
var quantities_array = quantities.split(',');
var totalFruit = 0;
var i;
for (i = 0; i < fruits_array.length; i++) {
if (fruits_array[i]==fruit) {
totalFruit = totalFruit + Number(quantities_array[i]);
} }
return totalFruit;
}
I tested this in both the mobile and web apps. Worked good! Hope it helps.
