Combined Operations

Some operations are not implemented directly, but can be achieved by combining operations.

Calculate Weighted Average along a hierarchy

SUBEACH Pattern

FINDFIRST and Populate

Calculate runtime of projects

Combined Growth Pattern

Break-down Data by Dimensions

Move yearly data by 6 months

Rollforward data with average growth rate from actuals

Getting the Days per Month/Year with DROPLEVEL() and EXPAND()

Difference between YOY_REL(), YOY_ABS(), and RATIO(PY())

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.