2 Replies Latest reply: Nov 19, 2012 6:32 AM by Tim Hop RSS

    variable in text box

      Hi All,

      I have a variable that works out an average for me, i am using this in a straight table with a product dimension then i have the totals summed up giving me a total of all the averages.  (Top table below)

      Does anyone know how i can use the variable in a text box but displaying the total instead

       

      this is my variable

      $(vTargetAvg_Listings)

      =

      avg({$<

      [it_target_type]={"Listings"},

      [ld_Dist]={"4"},

      [ld_Outlet_Check_Date]={">=$(=Timestamp(FirstDayCurrentFiscalYear))"}

      >}

      [it_target_value]

      )

      Capture.JPG