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

@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.