The best way to calculate a number of custom fields in a sequential order in one automation rule

yousefq

I’m using mathematical expressions to calculate a bunch of custom fields in a sequential order in one automation rule 

 

i.e to calculate the VAT field I’m using the following:

{{#=}} {{issue.Rent Amount}} * .15 {{/}}

 

then I’m using the output to calculate the total amount:

{{#=}} {{issue.Rent Amount}} + {{issue.VAT}} + {{issue.Other fees}} {{/}}

 

the problem is that sometimes the total amount doesn’t add the VAT 

My assumption is that there is some lag in filling the VAT field and by the time the automation runs the second line (Total amount), the VAT is still null. 

any recommendations on how to avoid this or if there is a better way to do these calculations?

much appreciated 

Kseniia Trushnikova

Hi @yousefq,

Try to add the action Re-fetch issue data before calculation of the total amount. It refreshes smart values with the latest field values.

The other solution is to calculate all at once:

{{#=}} {{issue.Rent Amount}} + ({{issue.Rent Amount}} * .15) + {{issue.Other fees}} {{/}}