0 Replies Latest reply on Dec 18, 2013 2:13 PM by fanny gallardo

    How to view Monthly Average Stock?

    fanny gallardo

      Hi, I currently have daily stock as a value and I wish to see the average stock in a month, but when I average I get the answer wrong. I tried to do the AVG(SUM(stock)) but if I open by year-month-day I get the monthly average for every day in the month. Is there a way I can view the average stock by month? I know it´s a semiaditive value. Thank you so much!