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.
@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.
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"
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.