Avatar

Level 10

Hi, There is nothing built in, you will have to write some script but it would not be much, the general pattern for summing a table column is to have something like this in the calculate event.

var sum = 0;
for (var i=0; i < {instanceManager}.count; i++)
sum += {field}.rawValue;
sum;

All you would need would be

var sum = 0;
for (var i=0; i < {instanceManager}.count; i++)

{

if ({costfield}.rawValue = 'Yes')

{
  sum += {field}.rawValue;

}

}
sum;

Where the things in curly brakets will be specific to your form.

Good luck

Bruce