Referencing custom total in a compute
A custom total is referenced in a custom compute with the syntax total. To reference a custom total without the override, use the this syntax:
(total(BusinessViews.Total Name).Measure)When referenced in a custom compute without the override, the value that is referenced by the custom total is used in the custom compute.
For example, this is the formula that is used to reference a custom total Revenue in a custom compute without the override.
(total(GeneralLedgerTotal."REVENUE").NetFunctionalAmount)When referenced in a custom compute, one or more dimension members (field values) in the custom total can be replaced. Replacing dimension members changes the value that the custom total is referencing. To reference a custom total with the override, use this syntax:
(total(BusinessViews.CustomTotal Name, BusinessClass.Field1 = Override Value, BusinessClass.Field2 =Override Value, BusinessClass.FieldN = Override Value).Measure)For example, this is the formula that is used to reference a custom total “Revenue” in a custom compute overriding the entity and the period:
(total(GeneralLedgerTotal."REVENUE", AccountingEntity=AccountingEntity, GeneralLedgerTotal.EntityYearPeriod=AllocationContext.Period).NetFunctionalAmount)| Parameters | Description |
|---|---|
| total | Identifies that a total is used. |
| GeneralLedgerTotal | Identifies a business view or address that holds the balances or totals to be obtained. |
| REVENUE | The custom total defined on GeneralLedgerTotal. |
| AccountingEntity | Identifies an accounting dimension on the GeneralLedgerTotal. |
| AccountingEntity | Identifies that the compute uses the accounting entity from the override dimension that is currently referenced by transfer pricing instead of the accounting entity that is specified in the custom total REVENUE. |
| GeneralLedgerTotal.EntityYearPeriod | Identifies a period dimension in the GeneralLedgerTotal. |
| AllocationContext.Period | Identifies that the compute uses the period from the context of the recharge calculation run instead of the period that is specified in the custom total REVENUE. |
| NetFunctionalAmount | Is a measure in the GeneralLedgerTotal. Identifies that the compute pulls the Net Functional Amount. |