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

[matticsphi]

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?

 

[matticsphi · Accepted solution]

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?

[matticsphi]

Got it, instead of 

columnSP = 0

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