4 Replies Latest reply: Dec 19, 2011 1:21 PM by Nancy Reid RSS

    Variable concatenated with $ not evaluating

    Nancy Reid

      I have created a table that includes metric names and metric variables (set as formulas) for two groups. In an expression in a straight table, the variable (which includes parentheses) is returned and I am concatenating it with a dollar sign. My hope was that this would force dollar sign expansion of the variable, but it isn't evaluating. Can anyone give me some advice on how to make this happen.

       

      See qwv attached.  First Expression is the field from the table that contains the variables (see Inline Load in CALCs tab in load script). Second Expression is the field (variable) concatenated with a dollar sign at the front. The Fourth Expression is what the result should be for Group 1.

       

      Thanks in advance!