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:
- 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).
- In the Active products view, a view rule specifies that the Status
attribute must contain the values Delivered, Approved for Development,
or Under Development.
- 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")