Automation rule using math not giving expected result

[Jenn Sherman]

I have custom fields on my epics and I'm using automation to populate one field based on the others but my result is incorrect.

I want to set Net Benefit to the result of Retention Benefit + Growth Benefit + Cost Savings - Dev Cost

Here's what's in my automation rule

{{#=}}{{issue.retention benefit|0}} + {{issue.growth benefit|0}} + {{issue.cost savings|0}} - {{issue.dev cost|0}}{{/}}

Retention benefit is edited to 40000 and the other fields have no values.  When the automation runs, Net Benefit is set from none to 0 when it should be set to 40000.  The automation is being triggered correctly but the value is being set incorrectly.  What should I change in my automation rule?

[John Funk · Accepted solution]

Hi Jennifer,

What you have looks correct to me. Maybe start by resetting Net Benefit to 0. Then I would cut it down to just two fields to see if that works then add one at a time in your testing. 

[Jenn Sherman]

Thanks! I had left off a character which I recognized when I cut it down to two fields.

[John Funk]

Great - glad I could help. 😊

[Bill Sheboy]

Hi @Jenn Sherman 

Your custom field names have embedded spaces.  Have you tried either enclosing the names in quotation marks or using using the custom field ID?

For example: {{#=}}{{issue."retention benefit"}} + {{issue."growth benefit"}} + {{issue."cost savings"}} - {{issue."dev cost"}}{{/}}

UPDATE: please disregard as I tried it with and without quotations and both worked for me.

Best regards,

Bill

[Jenn Sherman]

Thanks!