Calculating Tree from levels with Cumulative Framework Components

Cumulative Framework Demonstration

This demonstration workflow provides a "template" for building a cumulative calculation using a recursive loop with my Cumulative Framework Components

The aim here is that only the nodes marked by Orange Annotation boxes need to be changed for this to work with just about any non-basic cumulative calculation. (By non-basic cumulative calculation, I mean any cumulative calculation that requires more than the use of the "moving aggregation" node, and normally involves a multi-column mathematical calculation).

The initial Table Creator would obviously be replaced by your input data. This, or subsequent nodes (prior to the Cumulative Framework 1 component must contain ALL columns that will be included during processing where the previous value is important in the calculation, so this includes an initialised placeholder column for any value being calculated. e.g. If you are calculating "Cumulative Balance" in the rules/maths nodes later, you must make sure that the Cumulative Balance column already exists at the start of processing.

The Rule Engine and other nodes in the Orange annotations represent the place where any calculations take place. Other nodes may be used here as well as, or instead of , the Rule Engine etc.

The PREVIOUS row's brought forward value of any column is found in the PREV#colname version of that column. All columns included in the input to Cumulative Framework 1 will have a PREV#colname column created.