This article is for Structure Cloud.
Problem
I have a formula that aggregates values using the 'Sum over sub-items' option in its configuration. When this formula is referenced in another formula, the values are considered without the aggregation.
Solution
The ‘Sum over sub-items' option is only applied locally in its original formula; it doesn't transfer when the formula is referenced elsewhere. As a workaround, please use the aggregate sum{} function: https://help.tempo.io/structure/latest/aggregate-functions in the original formula instead, or integrate the original formula in the second formula as it is - this way you won’t need to reference it as a variable.