Skip Navigation

Newer Version Available

This content describes an older version of this product. View Latest

sum()

Returns the sum of a numeric field.

Example - Calculate the Total Meeting Time

Suppose that you have a database of meeting information. Use sum() to see that the total time spent meeting with each account.

1q = load "Meetings";
2q = group q by 'Company';
3q = foreach q generate 'Company' as 'Company', sum('MeetingDuration') as 'sum_meetings';