Multi-stage calculations - Cloud Automation

Chris F

Hi team,

I'm trying to automate the following calculation: (field 1 x field 2) + field 2

 

I've set up a global automation to calculate the first part (field 1 x field 2) but I'm unable to then take that output and use it for the follow up calculation.

I've tried splitting it into a second automation rule but that hasn't worked, so I'm wondering:

1. Is there a way to run step-by-step calculations in 1 rule

2. I couldn't find any documentation around the order at which global automation rules run (i.e Rule 1 runs and then Rule 2 etc). Is this documented anywhere?

Stefan Salzl

Hi @Chris F 

Could you please describe your whole use case in more details? What is your entry point/when should this be done and what is the expected result? This would also make a difference on how and where to do the calculation.

Furthermore: Are the fields across different projects or should the result be processed in a different project? Why are you considering your rule to be a global rule?

Something I you could try quickly is:

- create a variable (eg. varAddition) that does the 1st calculation (the addition of field1 + field2)
- create action "log action" that returns your variable (varAddition) for testing purpose.
- create another variable (eg. varMultiplication) that takes in the value of varAddition.asNumber (you have to convert to number with .asNumber as variables are stored as string) and the does the multiplication with the value of field2
- create action "log action" that returns your 2nd variable (varMultiplication) for testing purpose.

Hope that was helpful.

Best
Stefan