- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
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
Views
Replies
0 Likes
Total Likes