1 Reply Latest reply on Sep 14, 2016 7:45 AM by David Li

    Annualize Year to date data

    john utberg

      I have a viz that shows total sales for each prior year and also the current year to date (eg July 2016 to Aug 2016). The end date for the YTD period is determined by a filter.

       

      I would like to show an annualised sales estimate determined by the number of months of data.

       

      Eg July Sales $50,000

           August Sales $100,000

       

      Annualised Sales calculation would be

      (($50,000 + $100,000) / 2 )* 12 = $900,000

       

      I'm having difficulty counting the number of months (2 in this case) to create this calculation.

      I feel this should be quite easy but have not been able to find this through a search.