Hi,
I am trying to calculate a value called product score. Its a simple calculation of:
(High Level Estimate *-1)*Number of customers
I currently have an automation set up to capture the inverse of HLE (High Level Estimate) as a variable using:
{{issue.HLE.multiply(-1)}}
Number of customers is a label field which I have converted to a number in a variable using:
{{issue.Customers.size}}
I am then updating a field called product score with
{{#=}}{{InverseOfHLE}}*{{NumberOfCustomers}} {{/}}
However for this I am getting:
Unknown unary operator * at character position 1: *3
I also tried
{{#=}}{{InverseOfHLE.multiply({{NumberOfCustomers}})}} {{/}}
but for this I got :Failed to get value for InverseOfHLE.multiply({{NumberOfCustomers: {{#=}}{{InverseOfHLE.multiply({{NumberOfCustomers}})}} {{/}}
It would seem as though I'm trying something that is supported but I have my syntax wrong or there is some other basic error but at the moment I cannot see having read over the available documentation.
Hello @Sean Curran
Welcome. In my experience, you can either use math expression (using {{#=}} tags) or math operations, but not both together.So your second error is valid. First error seems more of a syntax issue.
Can you please log below 3 smart values and share screenshot of audit log:
{[issue.HLE}}
{{issue.Customers.size}}
{{#=}} {[issue.HLE}} * -1 * {{issue.Customers.size}} {{/}}
Thanks for the help. I didn't exactly work as above but it inspired me to simplify it.
I created a variable that simply held the value 1 and called it Inverse
Then used
{{#=}} ({{Inverse}} / {{issue.HLE}} )* {{issue.Customers.size}} {{/}}
This achieved what I was looking for, thank you!
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.