4 Replies Latest reply: Feb 6, 2017 9:05 AM by Peter Cammaert RSS

    Variable inside a variable in the load script

    Stuart Frew

      hi all,

       

      I have a variable which works fine when added manually to Settings > Variable Overview but does not work when loaded in from a text file via the load script.

       

      Here is the expression:-

       

      =if(isnull(GetFieldSelections(Metric_List)) or wildmatch(GetFieldSelections(Metric_List),'Customer Count'),

      num(sum({<CA={'1'} >} CUS),'###########,###'),

      num((sum({<CA={'1'} >} $(vMetric_Percent))/sum({<CA={'1'} >} CUS)),'#,##0.##%'))

       

      The variable reference is vMetric_Percent which has this value inside it =MetricLookup.

       

      When I try to load this expression from a text file unchanged instead of $(vMetric_Percent) it has been evaluated as =MetricLookup and therefore does not work.

       

      Is there any way to get around this problem?

       

      Thanks

      Stuart