Creating Named Range for use in formula

[mseg87]

Hi everyone

I was wondering if there was a way of creating a named range for use in a formula. I am inputting several tables from different excel sheets, then need to apply an identical formula to a particular column in each of them. 

The problem is the denominator in the formula is a variable that may change, so i wanted to set it as a 'named range' like I would be able to do in excel, so that when I change the value for the range, it can change throughout the Alteryx map, rather than having to change each hardcorded value, which creates room for error. Is there a way of doing this in Alteryx?

[andre347]

Could you mock up an example as I don't fully understand what you are trying to achieve here?

Thanks

[StephenR · Accepted solution]

What you want is a User Constant.  You enter the constant name into the Workflow Configuration, then you can use that constant in any formula (format: %constant%). 

[mseg87]

Thank you very much this solved it!