Can I add a custom field in JWM with a formula to show data based on other fields?

[Niki Woolston]

I want to add a custom field to show margin percent based on 2 other fields - Cost price, and revenue. I am manually typing in the margin to capture for reporting at the moment, but wondered if there was a way to have this automated based on the 2 other fields?

[Trudy Claspill]

Hello @Niki Woolston ,

Yes, you could use an Automation Rule to detect a change in value in either of the two source fields, the have the automation rule calculate the value and edit the issue to insert that value into the appropriate field.

Find the Field Value Changed trigger on this page.

https://support.atlassian.com/cloud-automation/docs/jira-automation-triggers/

Find the Edit Issue action on this page.

https://support.atlassian.com/cloud-automation/docs/jira-automation-actions/

Find information about doing math functions on this page.

https://support.atlassian.com/cloud-automation/docs/jira-smart-values-math-expressions/