Can automation compute an algebraic expression using multiple custom field values?

[Jordon Martig]

Can automation compute a math expression using multiple custom field values and take into account the order of operation? I am attempting to compute the following expression via automation. Each of the terms are custom value fields within the issue. 

(Units Consumed * Actual Unit Price) - (Cost Model Anticipated Units x Actual Price)= Custom Field Value. 

[Kian Stack Mumo Systems · Accepted solution]

@Jordon Martig, yes, this is possible!

I would check out this documentation, but the general process would look like this -

{{#=}}({{issue.Units Consumed}} * {issue.Actual Unit Price}}) - ({{issue.Cost Model Anticipated Units}} * {{issue.Actual Price}}){{/}}. 

You would want your trigger to be set to "Field Value Change" and then have the rule listen for the 4 fields in your equation.

[Jordon Martig]

Thanks for the info Kian. When I am trying to publish the rule, it is returning the following error: "Error parsing template: Failed to close '=' tag"

[Jordon Martig]

[Kian Stack Mumo Systems]

Ah! My apologies. While I was typing it in I missed a "{".

It should be this:
{{#=}}({{issue.Units Consumed}} * {issue.Actual Unit Price}}) - ({{issue.Cost Model Anticipated Units}} * {{issue.Actual Price}}){{/}}.

I'll edit the original answer to include the correct string as well!

[Jordon Martig]

that worked. Thank you so much for the help!