2 Replies Latest reply: Mar 31, 2015 5:39 AM by PAUL YEO RSS

    SET expression with Avg how to make it work in table and chart ?

    PAUL YEO

      Hi All

       

       

      I have SET expression for chart 1 is show correctly:-

       

       

      =(Avg({$<year = {$(=max(year))}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>} (STK_OPEN+STK_CLOSE)/2))

       

       

      I use the same expression at Table 1  i need it display 12.5 , now it display 7 , how to make it display 12.5

       

       

      when i click on month = 2 chart display Feb = 2.5 is correct , how to make tabble 1 display as 2.5 instead of 2 ?

       

       

      Paul