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.

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

From the Financial time grid attribute, you can calculate the sum of the Expenditures row in the Budget sheet. The calculation starts in cell A1 for the period that is specified in the Start Date and End Date attributes in the Phoenix element in the Projects module:
=SumTimeGridRow('Financials', "Financials", "Budget", "Expenditures", 'Projects!Phoenix!Start Date', 'Projects!Phoenix!End Date')
Tip: If the Start Date and End Date attributes are in the same element as the time grid attribute, type the references as Start Date and End Date.

What to do next

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

Feedback