2 Replies Latest reply on Feb 25, 2016 9:02 PM by Tharashasank Davuluru

    Create a rolling average Calculated field II

    Harnish Patel

      I currently have my data set up by month for 2014 and 2015. I have graphed 2015 using bars and I want to graph 2014 using two properties. I want a horizontal line representing the total at the end of 2014 (December) and would like that total to be calculated as the sum of the 12 months (numerators) divided by the sum of the 12 months (denominators). Essentially a rolling average every month ending in December.@