4 Replies Latest reply on Oct 15, 2013 3:39 PM by Ramon Martinez

    Total Averages from Blended Data

    Katherine Davies

      I have 2 sources of data

      - customer base

      - revenues

       

      I have blended these data sets together to get the ARPU (Revenues / Average customer base)

       

      the ARPUs for each account in the table below are correct

      However, I want to be able to show the overall total average as well

       

      This is my formula for average base (sourced from my customers data)

       

       

      This is my formula for the ARPU

       

       

      Can anyone please help with this?

       

      thanks