Heads up! On March 5, starting at 4:30 PM Central Time, our community will be undergoing scheduled maintenance for a few hours. During this time, you will find the site temporarily inaccessible. Thanks for your patience. Read more.

×
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