How to Sum Values in a Formula Column

Question

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:

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

Your advice would be appreciated. Thank you

Stepan Kholodov · Answer

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)