Description of enhancement required
Ability to allow to aggregate using Boolean mapping. Currently mapping can only be applied over List elements. It would simplify many formulas if we could simply SUM/PRODUCT over TRUE/FALSE Boolean values.
An example of enhancement - See example below
*List called "Client" with 3 items. Boolean property: “Client.Active” with following values:
TRUE
FALSE
TRUE
- * Module A with Client dimension has LineItem called "Data" with following data:
1
2
3
- Module B with no dimensions. Formulas in module B that could be very useful:
B.Data=A.Data [SUMTRUE: Client.Active] = 4
B.Data=A.Data [SUMFALSE: Client.Active] = 2
B.Data=A.Data [PRODUCTTRUE: Client.Active] = 3
B.Data=A.Data [PRODUCTFALSE: Client.Active] = 2
A story for why the enhancement is required, (how would it help the business process):
As mentioned, it would simplify many formulas if we could simply SUM/PRODUCT over TRUE/FALSE Boolean values.