Creating new variable to use in future formula

[nwatzlaf]

Good morning,

I am looking to create a new variable to use as the denominator in a future formula. The value comes from the addition of two summarize outputs. Is there an easy way to create a new variable called Total Units to be used in future formulas?

I can manually type in the value (sum of the two summarize outputs) as a denominator in the two future formula tools used for calculations, but it would be nice if it updated itself if the data set changes.

Thank you for your time,

Natalia

[LordNeilLord]

Hey @nwatzlaf 

Ignore my answer, I didn't read your post properly

In the workflow config you can create user constants which will be available through the workflow

[Kohlmeyl · Accepted solution]

Hello!

Using an append fields column after your summarize tools will allow you to create variables for total units. You can then add this back into the original data sets for further calculations, or append it to any other sources. Please see the attached for an example.

I hope this helps!

[nwatzlaf]

I had joins set up but appends make more sense. Thanks for your help @Kohlmeyl !!