Creating Named Range for use in formula

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?

Preparation

Accepted answers

StephenRuhl

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

All comments

andre347

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

Thanks

StephenRuhl

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

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

Aguisande 317