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

[Lean Li]

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?

[Stepan Kholodov _Tempo_ · Accepted solution]

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)