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.
×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?
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)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.