# Set default value as '0' for running velocity formula in 1st 2 sprints

**URL:** <https://community.eazybi.com/t/set-default-value-as-0-for-running-velocity-formula-in-1st-2-sprints/3549>\
**Category:** Questions & Answers\
**Created:** [January 24, 2020, 5:21pm UTC](https://community.eazybi.com/t/set-default-value-as-0-for-running-velocity-formula-in-1st-2-sprints/3549 "2020-01-24T17:21:14Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Gomez](https://community.eazybi.com/letter_avatar_proxy/v4/letter/g/d78d45/32.png) [@Gomez](https://community.eazybi.com/u/Gomez)\
**Post date:** [January 24, 2020, 5:21pm UTC](https://community.eazybi.com/t/set-default-value-as-0-for-running-velocity-formula-in-1st-2-sprints/3549/1 "2020-01-24T17:21:14Z")

</div>

Hi,

I want to calculate the running velocity (RV) for the latest 3 sprints, however I want the first 2 RV values defaulted to ‘0’ and calculation should start only from sprint 3 ie:

CASE  
WHEN  
– for closed sprints only  
[Sprint].CurrentMember.getBoolean(‘Closed’) AND  
NOT IsEmpty([Sprint].CurrentMember.get(‘Complete date’)) AND  
[Measures].[Sprint Story Points at closing] \> 0  
THEN  
AVG(  
Tail(  
– filter last 3 closed sprints starting from current sprint  
Filter(  
Head(  
Cache(ChildrenSet([Sprint].[Agg Sprints])),  
Rank([Sprint].CurrentMember,  
Cache(ChildrenSet([Sprint].[Agg Sprints]))  
)  
),  
– only sprints with committed story points are retrieved  
[Measures].[Sprint Story Points at closing] \> 0  
), 3  
),  
[Measures].[Sprint Story Points completed]  
)  
END

Please let me know how the 1st 2 RV values can be defaulted to zero whereas the other sprints can use this formula mentioned above.

![image](https://community.eazybi.com/uploads/default/original/2X/b/b06f7a23718de0237e28474004d8766c06943235.png)

---

<div class="post-metadata">

**Author:** ![martins.vanags](https://community.eazybi.com/user_avatar/community.eazybi.com/martins.vanags/32/8905_2.png) [@martins.vanags](https://community.eazybi.com/u/martins.vanags)\
**Post date:** [January 29, 2020, 1:35pm UTC](https://community.eazybi.com/t/set-default-value-as-0-for-running-velocity-formula-in-1st-2-sprints/3549/2 "2020-01-29T13:35:25Z")

</div>

Hi @Gomez

Welcome to eazyBI community.

Try this formula to limit the calculation and start calculation velocity from the 3rd sprint.

```
CASE
WHEN
--for closed sprints only
[Sprint].CurrentMember.getBoolean('Closed') 
AND
NOT IsEmpty([Sprint].CurrentMember.get('Complete date')) 
AND
[Measures].[Sprint Story Points at closing] > 0
AND
Rank([Sprint].CurrentMember,
Cache(ChildrenSet([Sprint].[Agg sprints]))
)>2
THEN
AVG(
Tail(
-- filter last 3 closed sprints starting from current sprint
Filter(
Head(
Cache(ChildrenSet([Sprint].[Agg sprints])),
Rank([Sprint].CurrentMember,
Cache(ChildrenSet([Sprint].[Agg sprints]))
)
),
-- only sprints with committed story points are retrieved
[Measures].[Sprint Story Points at closing] > 0
), 3
),
[Measures].[Sprint Story Points completed]
)
ELSE
0
END

```

It expects that you have a calculated member “Agg sprints” in “Sprint” dimension

Martins / eazyBI support