Jira Structure: Subtract from a SUM in Formula columns

[Diana]

I'm trying to create a Formula column that will read the item's story points, but if it's a parent Feature, don't include the Feature's story points. In the screenshot, I want the Story to read as "4" and its parent Feature to read as "4" not "5" because the Feature was assigned to "1" story point.

Reason why the feature was assigned a story point was during estimate/planning until we actually write the stories. (This is just an example, since we don't actually use "4" as a story point value.)

And since I have to export this for a report, and there are a lot of features with estimate sp, I'd rather have a formula column that excludes feature's sp so I don't have to clean up 100+ features.

How do I write the Formula column so that it takes the SUM of children story points, but then also subtract the parent's story points?

[Diana · Accepted solution]

Figured it out.

IF (issuetype = "Feature", 0, storypoints)

then select 'Sum over sub-items'