ListAttributeSum example

In this example, the ListAttributeSum business rule calculates the total NPV for a product portfolio by summing the NPV of the active products.

The Products module links to the Product Portfolios module. The Product Portfolios module has an Incoming Links attribute that lists all the products that connect to each portfolio, regardless of the status of the products. The Products module contains the Total NPV attribute. In the Product Portfolio module, the NPV value is relevant only for active products. Active products have the status Delivered, Approved for Development, or Under Development.

You can exclude inactive products from the total NPV by creating a view that displays only the relevant statuses. In this example, the following conditions exist:

  1. In the Total NPV attribute field of the Product Portfolios module, you must sum the content in the NPV Float attribute (ID 23) from the Product module, based on the elements in the Products Incoming Links attribute (ID 51) that are displayed in the Active products view (ID 38).
  2. In the Active products view, a view rule specifies that the Status attribute must contain the values Delivered, Approved for Development, or Under Development.
  3. The Admin member (ID 46) can access the Active products view.
To view the total NPV for the active products, enter the following default value in the Total NPV business rule container attribute:
=ListSumAttribute("51","38", "23", "46", 'Products', "listen_to= NPV", "listen_to=Status")

Feedback