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?
Solved! Go to Solution.
Could you mock up an example as I don't fully understand what you are trying to achieve here?
Thanks
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%).
Thank you very much this solved it!