Sum Up - Currency Rollup Calculation from Task to Epic

[Marina Koga]

Hi , 

Could anyone please advise what am I doing wrong?

The idea is to be triggered everytime Budget Consumption is updated on a Task level and updated to Parent Epic_Budget Consumption... 

Trigger details

Lookup issues

Edit Issue Field

Currently, as a result when Budget consumption updates on Task it clears the field in Epic. Will this have to do with OOTB setup?

Many Thanks

Marina

[Curt Holley · Accepted solution]

I think in the edit issue field you want to have {{lookupIssues.Budget Consuption.sum}}

[Marina Koga]

Thanks for you comment, is the below aligned to your suggestion? If so , this current rule is not rolling up to parent (epic) as expected.  Are you able to confirm? Many Thanks

[Curt Holley]

@Marina Koga You don't want to put {{lookupIssues.Budget Comsumption.Sum}} as the JQL for the lookup. You need to put that in the Edit Budget Comsumption action. 
You put the JQL that will provide the content in the look up

[Hauke Bruno Wollentin · Accepted solution]

In your branch rule you need the smart value {{triggerIssue.[...]}} instead of {{issue.[...]}} to get access to the fields of your Task and not your branch Epic.

[Marina Koga]

Thanks Hauke, 

Are you able to confirm if the below setup is as per your suggestion? This still not working and i believe i am missing something (being new on this, appreciate your help and patience). 

Many Thanks

Marina

[Hauke Bruno Wollentin]

I'm not 100% sure since I never had the case you described, but in the official documentation I can't find any function ".sum" like you used.

But still there are some math functions available that you could try out.

https://support.atlassian.com/cloud-automation/docs/jira-smart-values-math-expressions/

To be honest, since we have bought ScriptRunner I typically use Groovy to perform such calculations, but maybe it is possible by Jira Automation + Smart Values at all.