Ability to sum based on boolean
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:
- * Module A with Client dimension has LineItem called "Data" with following data:
- 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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.