Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


JIRA Structure: Forecast Column based on Velocity.

I am trying to create a column that gives a forecasted start date of Feature/ Story based on Velocity (which is also calculated). The Formula is accepted without errors, but the column shows DIV/0 error... Please help :)
WITH  END = DATE_SUBTRACT(today(), 56, "day"):
WITH velocity = if((resolved = DAYS_BETWEEN(Today(),END)); SUM{storypoints}/8): DATE_ADD(Today(), round(SUM#preceding{storypoints} / velocity)*5, "day")

1 answer

1 vote
David Niro
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Feb 08, 2023

Hello @Devender Singh ,

There are a few things you will want to check initially.

1) If velocity,  if((resolved = DAYS_BETWEEN(Today(),END)); SUM{storypoints}/8),
returns the result you expect it to.  

You can check this by adding it as a separate column in your structure

2) if velocity is mapping to the variable you expect it to.

You can check this from the list of variables below the formula.  Or by putting your cursor over the DATE_ADD() velocity.

3) If velocity in the new column you have added has values above 0 but below 1.  0.5 for example.  ROUND() without any modifiers returns a whole number.

The only other explanation would be if there is a non integer value being passed somewhere that expects an integer.  I don't see any clear indication of that.

Please also feel free to contact our support team directly via or through our customer portal


Thanks David for the response.. Will check your proposed solution..

Hi David, The proposed solution is not working, so I am reaching out to AML Support Team. 



Devender Singh

Suggest an answer

Log in or Sign up to answer
AUG Leaders

Atlassian Community Events