Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Structure formula: count sum original estimate of issues resolved in fixversion

Lean Li
Contributor
September 17, 2024

Hi,

I hava a structure that is grouped by:

- Fixversion

- Team

I am trying to count the sum of original estimates of issues resolved in each fixversion. Now my formula looks like this:

IF (Resolved_work AND statusCategory = "Done" AND resolutionDate < fixversion.Releasedate AND fixVersion.startDate < resolutionDate):

Sum{originalEstimate}

 

The formula returns some values but those with no value an error "Type?". How  can I fix the formula? And is the formula valid in the first place?

1 answer

1 accepted

1 vote
Answer accepted
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.
September 24, 2024

Hello @Lean Li 

The formula itself is correct; it depends on the setup of your structure and the referenced variables.

The TYPE? error, for example, can be returned if issues have more than one Fix version in them - this formula can only work with dates of a single version, and if there are multiple version, it's unclear which one should be considered.

I hope this helps. If you need further assistance with this or if you have more questions about Structure, please reach out to us directly at our support portal.

Best regards,
Stepan
Tempo (the Structure app vendor)

Suggest an answer

Log in or Sign up to answer
TAGS
atlassian, team '25, conference, certifications, bootcamps, training experience, anaheim ca,

Want to make the most of Team ‘25?

Spend the day sharpening your skills in Atlassian Cloud Organization Admin or Jira Administration, then take the exam onsite. Already ready? Take one - or more - of 12 different certification exams while you’re in Anaheim at Team' 25.

Learn more
AUG Leaders

Upcoming Jira Events