5 Replies Latest reply: Sep 24, 2013 11:02 AM by Felipe Carrera RSS

    Dollar sign expansion with parameter not working

    Felipe Carrera

      hi

      i defined a variable like:

      set vParameter =num(sum({$<%cus_track_wave__ID={'$(vLastWave)'},%cus_track_buyer__ID={$1}>}cus_track_qualityassessment)/count({$<%cus_track_wave__ID={'$(vLastWave)'},cus_track_quality={1,2,3,4,5,6,7},

      %cus_track_buyer__ID={$1}>}cus_track_quality),'#,##0%');

       

      and use it in the chart, under "Presentation" / add text as :

       

      =$(vParameter(2)), where 2 is the buyer_ID

       

      but it does not work. I need to use the formula as it is:

       

      =num(sum({$<%cus_track_wave__ID={'$(vLastWave)'},%cus_track_buyer__ID={2}>}cus_track_qualityassessment)/count({$<%cus_track_wave__ID={'$(vLastWave)'},cus_track_quality={1,2,3,4,5,6,7},%cus_track_buyer__ID={2}>}cus_track_quality),'#,##0%')

       

      where

      set vLastWave ='= MaxString(%cus_track_wave__ID)';

       

      Results for a filter is like this: the full Formula is getting what i need, but not the vParameter. The $(vParameter) shows me 53% instead of 64%,

       

      DimensionvParameterFormula
      Apr 201347.06%-
      May 201370.00%-
      Jun 201344.44%-
      Jul 201364.29%64.29%
      Total52.94%64.29%

       

      any idea, what i did wrong?

      many thanks