How can i get the sum of of all subtasks except epic and story to parent epic parent using smart val

[Mehdi Bouazza]

Hi Atlassian community

I want to create an automation that autocalculate sum of all worklog subtasks except Story and Epic and set the sum to parent Epic 

issue.childissue.timeSpent.sum get me the sum of all subtasks ,how can add a condition in this smart value ??

{{#=}}{{issue.childissue.timeSpent.sum}} / 60{{/}}

Thank you 

[Bill Sheboy · Accepted solution]

Hi @Mehdi Bouazza -- Welcome to the Atlassian Community!

Perhaps try using the Lookup Issues action, with JQL that narrows the issues to just the ones you want.  And then sum the values from the returned issues.

Kind regards,
Bill