Union

Use Union to Calculate Total Operating Expense

Generally, metrics are derived based on Individual drivers
Total Operating Expense is a metric calculated from Individual drivers such as IT Expense, Tools And Equipment Expense, and Consumable Expense.
Total Operating Expense = IT Expense + Tools And Equipment Expense + Consumable Expense
Total Operating Expense is the Formula node with the above formula with Input nodes- IT Expense, Tools And Equipment Expense, and Consumable Expense.
Formula can use multiple nodes with a combination of mathematical operands like +

Scenario details

Formula to calculate: Total Operating Expense = IT Expense + Tools And Equipment Expense + Consumable Expense.
IT Expense, Tools And Equipment Expense, and Consumable Expense are captured/maintained at the same level of details by GL Account
Module defined for Input template to maintain both the Input node values - Finance Planning
After calculation, the result will be posted to the same level of details by GL Account

Input Node

Node1 - IT Expense
Module - Module Finance Planning created with the below definition
- (Rows = GL Account, Columns = Time, Filter = Version)
Relation to be used in Formula = Merge

Node2 - Consumable Expense
Module - Module Finance Planning created with the below definition
- (Rows = GL Account, Columns = Time, Filter = Version)
Relation to be used in Formula = Union
Union Metric - IT Expense

Node3 - Tools And Equipment Expense
Module - Module Finance Planning created with the below definition
- (Rows = GL Account, Columns = Time, Filter = Version)
Relation to be used in Formula = Union
Union Metric - IT Expense

Expected Output Node

Formula Node - Total Operating Expense
Module - Same module Finance can used as the template & level of details are the same.
- (Rows = GL Account, Columns = Time, Filter = Version)
Formula to be used = IT Expense + Tools And Equipment Expense + Consumable Expense

There are 2 parts of creating the Formula node in Value Driver tree

Part 1 - Create Value driver

Step 1: To create a new value driver tree, Click on Drive menu

Under Calculations, click on + & select Rules to Open popup for capturing value driver details
- Description - Total Operating Expense
- Action Type - Select Value Driver
- Model - Finance Planning

Step 2: Click on + Add Rule on the level 2 header to open the node creation pane

General Tab

Step 3: Select the field member tagging to post the result of the calculation

Click on the filter Icon on the right of the each of fields and make relevant selections

Note - By default - the output put is posted as "Same as source", even if left not selected for fields.

Step 4: Click on Input Tab and Open node - IT Expense

Step 5: Next on Input Tab itself, open Input node - Tools And Equipment Expense

Step 6: Next on Input Tab itself, open Input node - Consumable Expense

Step 7: Click on save

Last updated 1 year ago