8 Replies Latest reply: Mar 29, 2015 7:47 AM by Yeo Poh sai RSS

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

    Yeo Poh sai

      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.