The Atlassian Community Forums are currently in read-only mode. We will be relaunching on a new platform on September 22 (read more here). We apologize for the extended downtime. For concerns or questions, please email communitymanagers@atlassian.com. See you on the other side, on the new Atlassian Community Forums! :)

×

Forums

Articles
Create
cancel
Showing results forĀ 
Search instead forĀ 
Did you mean:Ā 

Can you divide contents of a numeric custom field by contents of another numeric field?

Cat LeDevic
May 30, 2023

I have two custom numeric fields. I need to divide the contents of the first one by the contents of the second and place the answer in a third. I have values in the first two fields set. It's likely a syntax thing - thanks so much!

1 answer

1 accepted

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

1 vote
Answer accepted
Mike - Dreamsuite Consulting
Community Champion
May 31, 2023
Mike - Dreamsuite Consulting
Community Champion
May 31, 2023

I did a button for ease of demonstration, you can do is as an automation too:

When custom fields "Field1" and "Field2" are completed, set custom field "Result" to {{%Field1}} / {{%Field2}}

Like • Cat LeDevic likes this
Mike - Dreamsuite Consulting
Community Champion
May 31, 2023

You can also use parenthesis:

Screenshot 2023-05-31 134132.pngezgif.com-video-to-gif (1).gif

Like • Cat LeDevic likes this
Cat LeDevic
May 31, 2023

Thank you a million times. I feel like a total moron these days - caught a rare brain infection a year ago. Thank gawd I can still write. Developing is my side gig, and honestly I had no clue if I was able to still do it - with a product I've never seen before! Had it been PHP, Python, or the easy HTML, CSS, and JS - I think I'd still have had issues, but not like THIS lol! Unable to divide for a result? Someone needs to revoke my developer card, I tell ya!
I was so close to the correct syntax - a year ago it would have been a breeze.

The client is a start-up, they purchased Trello. It's a superb product: my client even gets what I'm trying to do! Way to make a product super-usable. (And not too bad for, cough, developers with a now-funky brain! THANK YOU!!

And - I'll be bock (thanks to Arnold too.)

TAGS
AUG Leaders

Atlassian Community Events