10 Replies Latest reply: Apr 2, 2015 6:33 AM by PAUL YEO RSS

    SET expression after add month*30 chart 2 not working correctly ?

    PAUL YEO

      Hi All

       

       

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

       

       

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

       

       

      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)/1000)

       

       

      I have SET expression for Table 2 is show correctly:-

       

       

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

       

       

      I have SET expression for chart 2 is show not correctly result :-

       

       

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

       

       

      May i know how to modify chart 2 expression , so that it can show correct result as table 2 ?

       

       

      How to check ?

      Step 1 click on step 1 button , you should note that Table 1 and Chart 1 and table 2 display correct value , and chart 2 show wrong value. because chart 2 dec should 593,000.9 is wrong , it should be show 49,428.7

       

       

      Step 2 click on step 2 button , you should note that Table 1 and Chart 1 and table 2 display correct value , and chart 2 show wrong value. because chart 2 dec should 130,269.3 is wrong , it should be show 43,426.1

       

       

       

       

      Paul