C2C Formulas using Dimensions

Calculate results for each Dimension in your inputs

If you have our Dimensions functionality switched on, and you use C2C formulas in your budgets, this article is for you.

The standard operation of the C2C formula calculates the result of your formula by either working with the total of each source category, or summing up the totals at the sub category line level (for instance if you click the "Calculate at Sub Category" option, you might multiple sub category 1 in source category A x sub category 1 in source category B, line 2 x line 2, line 3 x line 3 etc).

With Dimensions switched on you will see an additional option in your C2C edit screen - Dimensions Level.

 

This will match up Dimensions in your source categories, so you will only get a result when you have the same dimension in each of your source categories. Like Dimensions do not need to appear on the same row for the formula to work.

See table below for an example: