browse_total_rows

addBrowseColumnTotal()

The function addBrowseColumnTotal() can be added to a form's Custom Code to add a total row (or multiple total rows) at the bottom of a Browse Table.

addBrowseColumnTotal(columns, op, number, title); 

The function takes the following arguments:

• columns: Columns for which a total will be displayed. array of columns. E.g. ['1','2']
• op (operation): Sum: totalOperations.SUM, Average: totalOperations.AVG, Weighted Average: totalOperations.AVG_W
• (total row) number: Number of the total row. There can be more than one total row.
• (total row) title: Title of the total row

Example 1: Add a total row (sum)

  addBrowseColumnTotal(['1','2','3','4'], totalOperations.SUM, 1, 'Total');  

Example 2: Adding multiple total rows

  addBrowseColumnTotal(['1','2','3','4'], totalOperations.SUM, 1, 'Sum');
  addBrowseColumnTotal(['1','2','3','4'], totalOperations.AVG, 2, 'Average');

Using the function in several Browse Screens.

If you want to use the addBrowseColumnTotal() function in several Browse Screens, you should create an external JavaScript file, instead of including the same script in every form (redundancy). Place the browse_total_rows.js in a subfolder of nuBuilder root directory (e.g. /libs), and then refer to it by adding this JavaScript to (Setup ->) Header:

</script>
<script src='libs/browse_total_rows.js' type='text/javascript'></script>