Calculating the sum of a time grid row

You can use the SumTimeGridRow business rule to calculate the sum of a time grid row in a given time span. The result is displayed in the business rule container attribute. If the values in the row change, the sum is automatically updated. The cells to be included in the calculation must either be date or attribute, and not a mix of both.

Before you begin

To use the SumTimeGridRow business rule, you need the following information:

Procedure

  1. Create an integer attribute.
  2. In the integer attribute, enter your business rule in the following format:
    =SumTimeGridRow('Time Grid Attribute Name',"Time Grid Attribute Name", "Sheet Name", "Row Name")
  3. Click Save.

Results

The sum of the time grid row is calculated as a decimal number, and displayed in the integer attribute.
Note: SumTimeGridRow is calculated as a decimal. To display the sum as a decimal, enter the business rule in a float attribute instead.

Example

What to do next

Use the sum of the costs in a project to calculate the total project costs in a portfolio.

Feedback