How can I make an Automation for advanced math to multiply and then add in to one field.

[Ethan Vaughan VF]

The function I am attempting is something is this:

{{#=}}{{issue.10146}} * 85 + {{issue.10147}} * 125 + {{issue.10148}} * 135 + {{issue.10149}} * 150 + {{issue.10150}} * 165 + {{issue.10151}} * 175 + {{issue.10152}} * 185 + {{issue.10153}} * 235 + {{issue.10154}} * 25 + {{issue.10155}} * 35 + {{issue.10156}} * 45 + {{issue.10157}} * 55 + {{issue.10158}} * 65 + {{issue.10159}} * 75{{/}}

These are all number fields and trying to add all these up into one number field as well.
The attempt is the multiple multiple contractors' rates by the hours needed, and add them together in one Total Cost field.

When attempting to run this rule, the audit comes back with this:

Action details:

Error rendering smart-values when executing this rule:Unknown unary operator '*' at position 1: * 85 + * 125 + * 135 + * 150 + * 165 + * 175 + * 185 + * 235 + * 25 + * 35 + * 45 + * 55 + * 65 + * 75

Thanks

[John McKiernan · Accepted solution]

Hi there, 

That's a lot of numbers! So it seems the problem and solution is a simple one. 

Currently, you have the smart value written incorrectly as {{issue.10146}} 

It should be {{issue.customfield_10146}} 

If you make that change for all of the numbers, this should work for you. 

You can see more about smart values here: https://docs.automationforjira.com/working-with-issue-data/available-values.html#available-values 

Let me know if you run into any trouble! 

Cheers,

John 

[Ethan Vaughan VF]

Updated the rule accordingly right now, recieving the same errors. Usury operator

[John McKiernan]

Hi there,

No problem, I will need to take a look into the rule config and the audit log. Keeping privacy in mind, could you please send through a support ticket with screenshots of the audit log and the rule config to our support team here:

https://codebarrel.atlassian.net/servicedesk/customer/portal/1/create/3

Thanks,

John 

[Bill Sheboy]

Hi there, @John McKiernan1 

Was there a solution that can be shared for the formula / rule error?

Thanks, and best regards,

Bill