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.
The content in this article has not been evaluated for all Anaplan implementations and may not be recommended for your specific situation.
Please consult your internal administrators prior to applying any of the ideas or steps in this article.