Divide not working in automation

Valerie Prater

I have an automation set to calculate total comments and then then to divide and figure out total comments per page.  The automation isn't giving any errors but the total comments per page is coming out as none.

 

I just had two statements changing the fields but I tried converting them to variables to see what numbers I was getting.

 

commentsPerPage = {{totalComments.divide(issue."Total Pages").format("###.##")}}

Bill Sheboy

Hi @Valerie Prater -- Welcome to the Atlassian Community!

Here are a couple of things to try...

First, created variables are text.  To use them as a number use asNumber to convert the value before math operations/functions.

Next, smart values for fields are name, spacing, and case-sensitive.  To confirm you have the correct ones for your custom fields, please take a look at this how-to article: https://support.atlassian.com/cloud-automation/docs/find-the-smart-value-for-a-field/

Kind regards,
Bill