3 Replies Latest reply: Aug 28, 2014 10:37 PM by Jonathan Poole RSS

    3 month moving/rolling average in text box?

    Sifat Rahman

      Is this possible? Usually the rolling averages are shown inside graphs where dimension is defined.

       

      rangeavg(above(sum(Sales),0,3) - how could I define it such that it shows the 3 month average of the current month or week inside a textbox? Thanks.