This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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?