Exclude "No value" folder in Structure formula when grouping items?

[Dan Giordano]

I am trying to show the average story points per sprint in a formula column of a Structure board which is grouping my team's backlog by sprint.  How can I exclude the items in the "No value" folder when I am grouping by sprint?

The formula I am using is just  

 avg{storypoints}

[Stepan Kholodov _Tempo_ · Accepted solution]

Hello @Dan Giordano 

You can try: avg{if sprint: storypoints}

This formula will only consider Story Points of issues that have Sprints assigned to them.

I hope this helps. If you need further assistance 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)