Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Creating Named Range for use in formula

Highlighted
Atom

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?

 

 

Highlighted
Alteryx Certified Partner

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

 

Thanks

Highlighted
Alteryx
Alteryx

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%). 

Regards,
Stephen Ruhl
Customer Support Engineer

Highlighted
Atom

Thank you very much this solved it!

Labels