Discussions

 View Only
  • 1.  how to use variable in formula field

    Posted 09-06-2019 07:42
    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
    ------------------------------


  • 2.  RE: how to use variable in formula field

    Posted 09-06-2019 09:24
    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
    ------------------------------



  • 3.  RE: how to use variable in formula field

    Posted 09-11-2019 09:39
    Thanks a lot Adam. I recently found that only text columns can be used for variables.

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