Forum Discussion

PushpakumarGna1's avatar
PushpakumarGna1
Qrew Assistant Captain
6 years ago

how to use variable in formula field

Hi Everyone,

Can you please let me know how to use a variable in a formula field.

Suppose if i have a column X , I need to create a new formula numeric column X / Variable.

Note : I am declaring the variable value in variable component.

Thanks

------------------------------
Pushpakumar Gnanadurai
------------------------------
  • AdamKeever1's avatar
    AdamKeever1
    Qrew Commander
    6 years ago
    All you need to do is wrap the name of your variable in square brackets. So if you name your variable formula1, your equation in your formula field would look like this:

    [column X] / [formula1]​


    ------------------------------
    Adam Keever
    ------------------------------
    • PushpakumarGna1's avatar
      PushpakumarGna1
      Qrew Assistant Captain
      6 years ago
      Thanks a lot Adam. I recently found that only text columns can be used for variables.

      ------------------------------
      Pushpakumar Gnanadurai
      ------------------------------