4 Replies Latest reply on Dec 18, 2015 2:55 AM by coffeemaker

    Evaluate Field Content

    coffeemaker

      Hi All,

       

      Hope someone can help me with this. Have spent hours on it and still not anywhere near a solution.

       

      I am trying to evaluate a field but somehow I think I must have missed out something.

       

      MyTable::MyField

       

      $$Result.

       

      The evaluate function I use : Evaluate ((Get(LayoutTableName)&"::MyField"))

       

      Assuming the input in My field is 9+9, the evaluate function returns 9+9, which is not what I want. What I want is $$Result to be 18.

       

      I have tried to add the quotation marks but it is not working. Also I fiddling around sometimes returns a question mark but not the results I need.

       

      However if I were to use the actual table and field  name -  it works just fine. ie. Evaluate(MyTable::MyField) will return the correct result 18.

       

      I hope someone can help me see where I go wrong.

       

       

      Thanks in advance