FormulaChangelog

Node Properties Explanation

[NODE].PARENT

[NODE].PARENT refers to the parent node of the NODE. This cannot be used seperately and should be used along with other functions while referring to the Parent node.

Example

If the node Sales has child nodes, East, West, South and Central, the node Sales can be referred to as [East].PARENT, [West].PARENT, [South].PARENT or [Central].PARENT.

[NODE].CHILDREN

[NODE].CHILDREN refers to the children nodes of the NODE. This cannot be used seperately and should be used along with other functions while referring to the Child nodes.

Example

If the node Sales has child nodes, East, West, South and Central, the child nodes of Sales can be referred to using [Sales].CHILDREN.

Sample Dataset 1

We will use the following dataset for explaining the below functions.

Profit Node and its children

[NODE].VISIBLE_CHILDREN

[NODE].VISIBLE_CHILDREN refers to the children nodes of the NODE, that are visible and not hidden. This cannot be used separately and should be used along with any aggregation functions like SUM, Product, Subtract etc.

For example, if we want to calculate the sum of visible children of the Profit node, we will use the formula SUM([Profit].VISIBLE_CHILDREN)

Sum of Profit node's visible children

[NODE].HIDDEN_CHILDREN

[NODE].HIDDEN_CHILDREN refers to the children nodes of the NODE, that are hidden. This cannot be used separately and should be used along with any aggregation functions like SUM, Product, Subtract etc.

If we want to calculate the sum of hidden children of the Expenses node, we will give the formula as,

SUM([Expenses].HIDDEN_CHILDREN)

Sum of Expense node's hidden children

[NODE].TITLE*

[NODE].TITLE returns the node's TITLE.

Note: *This function's development is in progress.

Sample Dataset 2

This is a dataset of [Sales] node. This is used for the below examples.

Sales Node

[NODE].ACT

[NODE].ACT refers to the Simulated Series of the node. This can only be used along with other functions like SUM, GET(CPI).

SUM([Sales].act) will return the simulated values of the sales node.

Simulated Series

[NODE].TGT

[NODE].TGT refers to the Comparison Series of the node. This can only be used along with other functions like SUM, GET(CPI).

SUM([Sales].tgt) will return the comparison values of the sales node.

Comparison Series

[NODE].BASE

[NODE].BASE refers to the Baseline Series of the node. This can only be used along with other functions like SUM, GET(CPI).

SUM([Sales].base) will return the baseline values of the sales node.

Baseline Series

Sample Dataset 3:

This is a dataset of [Cost of Sales] node. This is used for the below examples.

Cost of Sales

[NODE].ALL_PERIODS

[NODE].ALL_PERIODS refers to all period values. This can only be used along with other functions like SUM, GET(CPI).

[Cost of Sales].ALL_PERIODS.GET(CPI) will return baseline values of all periods.

Baseline Series

[NODE].SIM_PERIODS

[NODE].SIM_PERIODS refers to simulated period values. This can only be used along with other functions like SUM, GET(CPI).

The periods in a model are defined from Jan to Dec and the active simulation period is from Jun to Dec.

[Cost of Sales].SIM_PERIODS.GET(CPI) will return Simulated values of all Sim periods.

Simulated Series

Sample Dataset 4:

This is a dataset of [Sales] node. This is used for the below examples.

Sales Node

[NODE].act.ALL_PERIODS

[NODE].act.ALL_PERIODS returns all period values of the simulated series. This can only be used along with other functions like SUM, GET(CPI).

[Sales].act.ALL_PERIODS.GET(CPI) will return Simulated values of all periods.

Simulated Series

[NODE].tgt.ALL_PERIODS

[NODE].tgt.ALL_PERIODS returns all period values of the comparison series. This can only be used along with other functions like SUM, GET(CPI).

[Sales].tgt.ALL_PERIODS.GET(CPI) will return Comparison Series value of all periods.

Comparison Series

[NODE].base.ALL_PERIODS

[NODE].base.ALL_PERIODS returns all period values of the baseline series.This can only be used along with other functions like SUM, GET(CPI).

[Sales].base.ALL_PERIODS.GET(CPI) will return Baseline Series value of all periods.

Baseline Series

[NODE].act.SIM_PERIODS

[NODE].act.SIM_PERIODS returns simulated period values of the simulated series.This can only be used along with other functions like SUM, GET(CPI).

The periods in a model are defined from Jan to Dec and the active simulation period is from Jun to Dec.

[Sales].act.SIM_PERIODS.GET(CPI) will return simulated period values of the simulated series.

Simulated Series

[NODE].tgt.SIM_PERIODS

[NODE].tgt.SIM_PERIODS returns simulated period values of the comparison series.This can only be used along with other functions like SUM, GET(CPI).

The periods in a model are defined from Jan to Dec and the active simulation period is from Jun to Dec.

[Sales].tgt.SIM_PERIODS.GET(CPI) will return simulated period values of the comparison series.

Comparison Series

[NODE].base.SIM_PERIODS

[NODE].base.SIM_PERIODS returns simulated period values of the baseline series.This can only be used along with other functions like SUM, GET(CPI).

The periods in a model are defined from Jan to Dec and the active simulation period is from Jun to Dec.

[Sales].base.SIM_PERIODS.GET(CPI) will return simulated period values of the baseline series.

Simulated Series

Sample Dataset 5:

This is a dataset of [Sales] node. This is used for the below examples.

Sales Node

[NODE].TOTAL

[NODE].TOTAL returns the all period aggregated value of the node.

[Sales].TOTAL

Total Sales

[NODE].PTD

[NODE].PTD returns the period till date aggregated value of the node. The seleted months in Simulte tab will be considered for the PTD calculation and value display should be Sim Months. If Full Year is selected Full Year Values will be Shown instead of PTD.

Here Sim Months is selected and the period is set From Jan to Mar.

[Sales].PTD

Period to Date Sales

[NODE].SEL

[NODE].SEL returns the simulation period aggregated value of the node.

[Sales].SEL

Total Simulated Sales

Sample Dataset 6:

This is a dataset of [Sales] node. This is used for the below examples.

Sales Node

[NODE].RANGE(START_INDEX,END_INDEX)

[NODE].RANGE(start_index,end_index) returns selected range values of the node. The Value display should be selected as Sim.months and the number of periods should be selected in Sim periods. If we keep it as Jan to Apr it will give us 4 month's value. If we keep it as Jan to may it will give us 5 month's value.

SUM([Sales].RANGE(9,12)) will return the values of Sept to Dec as the full period value.

Sum of Baseline Series from Sept to Dec

[NODE].act.RANGE(START_INDEX,END_INDEX)

[NODE].act.RANGE(start_index,end_index) returns selected range values of Simulated Series.

SUM([Sales].act.RANGE(9,12)) will return the simulated values of Sept to Dec as the full period value.

Sum of Simulated Series from Sept to Dec

[NODE].base.RANGE(START_INDEX,END_INDEX)

[NODE].base.RANGE(start_index,end_index) returns selected range values of Baseline Series.

SUM([Sales].base.RANGE(9,12)) will return the baseline values of Sept to Dec as the full period value.

Sum of Baseline Series from Sept to Dec

[NODE].tgt.RANGE(START_INDEX,END_INDEX)

[NODE].tgt.RANGE(start_index,end_index) returns selected range values of Comparison Series.

SUM([Sales].tgt.RANGE(9,12)) will return the comparison values of Sept to Dec as the full period value.

Sum of Comparison Series from Sept to Dec

[NODE].GET(PERIOD_INDEX)

[NODE].GET(period_index) returns the selected period value of the node.

[Sales].GET(6) will return the value of 6th month which is June

June month Baseline values

[NODE].act.GET(PERIOD_INDEX)

[NODE].act.GET(period_index) returns the selected period value of the Simulated Series.

[Sales].act.GET(6) will return the simulated value of the month June

June month Simulated values

[NODE].base.GET(PERIOD_INDEX)

[NODE].base.GET(period_index) returns the selected period value of the Baseline Series.

[Sales].base.GET(6) will return the baseline value of the month June

June month Baseline values

[NODE].tgt.GET(PERIOD_INDEX)

[NODE].tgt.GET(period_index) returns the selected period value of the Comparison Series.

[Sales].tgt.GET(6) will return the comparison value of the month June

June month Comparison values

[NODE].LastNPeriods(n)

[NODE].LastNPeriods(n) returns selected range values of the node. This cannot be used seperately and should be used along with other aggregate functions like SUM,PRODUCT,SUBTRACT.

If we want to calculate the sum of previous two periods, the formula should be SUM([Sales].LastNPeriods(2))

Sum of Baseline Values of Previous 2 Periods

[NODE].act.LASTNPERIODS(N)

[NODE].act.LastNPeriods(n) returns selected range values of the Simulated Series.This cannot be used seperately and should be used along with other aggregate functions like SUM,PRODUCT,SUBTRACT.

SUM([Sales].act.LastNPeriods(2)) will return the Sum of the simulated values of the previous two periods.

Sum of Simulated Values of Previous 2 Periods

[NODE].base.LASTNPERIODS(N)

[NODE].base.LastNPeriods(n) returns selected range values of the Baseline Series.This cannot be used seperately and should be used along with other aggregate functions like SUM,PRODUCT,SUBTRACT.

SUM([Sales].base.LastNPeriods(2)) will return the Sum of the baseline values of the previous two periods.

Sum of Baseline Values of Previous 2 Periods

[NODE].tgt.LASTNPERIODS(N)

[NODE].tgt.LastNPeriods(n) returns selected range values of the Comparison Series.This cannot be used seperately and should be used along with other aggregate functions like SUM,PRODUCT,SUBTRACT.

SUM([Sales].tgt.LastNPeriods(2)) will return the Sum of the comparison values of the previous two periods

Sum of Comparison Values of Previous 2 Periods
PreviousNode PropertiesNextGlobal Settings

Last updated