Structures: Story points being added to formula though no stories fall in query

mattics phi October 31, 2023

Hi!  I have a weird issues with Structures.  Here is my formula

 

IF JQL {issuetype in ("Mega Epic", "Epic", Initiative) } :
SUM {
IF JQL { issuetype not in ("Mega Epic", "Epic", Initiative) and status in (Open)} :
columnSP
else :
columnSP = 0
}

 

with this said, below is the screenshot of the problem on my structure board.  No tickets are in the "Open" status but I still see story points = 2 (highlighted in red).  Why is this happening?

 

 

Screenshot 2023-10-31 at 10.25.35 AM.png 

1 answer

1 accepted

0 votes
Answer accepted
mattics phi October 31, 2023

I did a little digging and it's because of the 0 story point issues.  There's something wrong in the instance when Story = closed and story points = 0.  Is this a bug?

mattics phi October 31, 2023

Got it, instead of 

columnSP = 0

 in the else statement, I just put 0 and it worked :D

Suggest an answer

Log in or Sign up to answer