Not by using wild cards. But there is a good chance that an alternative expression will produce the needed result. Can you explain in more detail what you need to have happen here?
OK. I have data on "sheep_animal_density". I want to create a new field called "equivalent_animal_density" which is calculated as "equivalent_animal_density = "sheep animal density * AUE" where AUE is animal unit equivalence and can vary from 0.1 to 0.2. Is there a way to define a variable AUE such that it can be adjusted as a sensitivity parameter?
That's about as clear as mud.
What do you mean by a "sensitivity parameter"?
Can you provide an expression using wild cards that illustrates exactly what you want to do with that value?
I'm so new to do this that I don't know what wild cards is? Let me try a different way of asking my question. Can a field that is a calculation type contain a variable that I can easily change the value of? I have roughly 1 million records, and do not want to have to create a separate field for the calculation just so that I can refer to that separate field in the calculation.
I misunderstood your original post taking the asterisk in param*y to be a wild card like you'd use in a find instead of the multiplication operator.
You can refer to global fields and global variables in your calculation fields and fields with auto-entered calculations. You can then change the value of the field or variable to change what result is computed by that field.
You can define a field with the global storage field option in any table and it can be accessed from any calculation, script or field in your file. I often set up a table of global fields for all global fields not used as match fields in a relationship as a better way to manage them.
Globals::GlobalField * y
Global variables have to be set by a script step, but you can have several different buttons that assign different values to that variable if that works for what you have in mind.
$$GlobalVariable * y
This is excellent! Thanks for the help. I really appreciate it