8 Replies Latest reply: Mar 29, 2015 7:47 AM by PAUL YEO RSS

    SET expression compute average stock using open stock and close stock field.

    PAUL YEO

      Hi All

       

       

      I have this SET expression (Table 2) to display STOCK field to compute average amount. which is working fine.

       

       

      Avg({$<year = {$(=max(year))}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>} (STOCK)/1)

       

       

      But My accountant not allow me using STOCK field and need me using Open stock and Close stock field to compute the average stcok by month. ( See Table 1 )

       

       

      Any idea how to modify the above expression ?

       

       

      Note that i cannot use Table 1 expression , as it is not SET expression.

       

       

      Paul