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 edited

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

1 vote
Answer accepted
Dreamsuite Mike
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
May 31, 2023
Dreamsuite Mike
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
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
Dreamsuite Mike
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
May 31, 2023

You can also use parenthesis:

Screenshot 2023-05-31 134132.png ezgif.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.)

Like • Dreamsuite Mike likes this

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events