Is there a way to change the name of the field that a formula is altering based on user input? For example, I have the following formula:
IF IsNull([202307]) THEN
IF IsNull([202309]) Or [202309] = 0 THEN [202308]
ELSE [202308] * [202308]/[202309]
ENDIF
ELSE [202307]
ENDIF
This changes the field "202307". However, this field will change each quarter. Is there a way for the user to be able to input the name of the field to be changed, with the above formula being applied to their selected field?
@
@tlhoyt wrote:Is there a way to change the name of the field that a formula is altering based on user input? For example, I have the following formula:
IF IsNull([202307]) THEN
IF IsNull([202309]) Or [202309] = 0 THEN [202308]
ELSE [202308] * [202308]/[202309]
ENDIF
ELSE [202307]
ENDIF
This changes the field "202307". However, this field will change each quarter. Is there a way for the user to be able to input the name of the field to be changed, with the above formula being applied to their selected field?
@tlhoyt Yes, what you want is an Analytic App where someone can enter freeform text. Watch the first 4 Interactive Lessons here: https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons/label-name/Creating%2...Alternately you may want to provide them with a dropdown selection, In which case watch the first 3 lessons and the one on creating drop-downs.StellaBon
But can their freeform text change the field that the formula is being applied to? Or only the fields in the formula itself?
Like this?
I don't see anything?