how to calculate

[Viktoria Soldatova]

How can I make this formula in Automation
- value change make

=(Days left this year)*Field1/Days past this year

[Bill Sheboy]

Hi @Viktoria Soldatova 

That should be possible using the date / time and math functions:

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

Perhaps start by using the startOfMonth() and endOfMonth() and perform diff() operations relative to {{now}}

I recommend using a test rule to write your calculations to the audit log to confirm they work as needed.

Kind regards,
Bill

[Viktoria Soldatova]

it does not work

[Viktoria Soldatova]

you can write the formula if you know how. thanks

[Bill Sheboy]

For a question like this, context is important.  So the community can help, please provide:

• explain what is not working as you expected
• an image of your complete automation rule in one image
• an image of the rule action(s) where you are performing the calculation
• an image of the audit log details showing the rule execution