How to Sum Values in a Formula Column

Paul Doman
Contributor
October 29, 2024

Issues have a formula calculation to compute a value based on the content of notes and other attributes. The result is returned as Numeric and is the formula attribute ObjMin in the screenshot below.

Issues are GROUPed according to another formula.

I wish to calculate for each group, the sum of all the ObjMin values in each issue.

My research and attempts have resulted in trying formulae like:

           

Snag_8cb36d53.png

 

However this does not produce a sum at the parent/group level.

Your advice would be appreciated. Thank you

1 answer

0 votes
Stepan Kholodov _Tempo_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
October 29, 2024

Hello @Paul Doman 

The 'Sum over sub-items' checkmark doesn't work together with aggregate functions in formulas (in your formulas, the SUM function is an aggregate function). Either one of the two should be used for getting proper results.

Summing up values from the bottom levels of the hierarchy to the top can work with a formula like this:

sum{variable_name}

If this doesn't work as you expect, we would need to have a detailed look at your setup to understand it better, and to be able to recommend anything more specific. Please reach out to us directly at our support portal and we'll go from there.

Best regards,
Stepan
Tempo (the Structure app vendor)

Suggest an answer

Log in or Sign up to answer