topic Re: Creating new variable to use in future formula in Alteryx Designer Desktop Discussions

Creating new variable to use in future formula

nwatzlaf — Wed, 14 Aug 2019 13:01:34 GMT

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

Re: Creating new variable to use in future formula

LordNeilLord — Wed, 14 Aug 2019 13:21:15 GMT

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~~

Re: Creating new variable to use in future formula

Kohlmeyl — Wed, 14 Aug 2019 13:09:48 GMT

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!

Re: Creating new variable to use in future formula

nwatzlaf — Wed, 14 Aug 2019 13:42:20 GMT

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