1 Reply Latest reply on May 11, 2013 10:11 AM by Shawn Wallwork

    When creating a daily average I receive this error: Cannot mix aggregate and non-aggregate into one calculation

    Andre Molnar

      Hello All,

      I am attempting to create a daily average for spend where their is a running total for both spend and number of days in month.

      Here is my formula:

      It is basically

      daily spend average= running spend / running total of days in month


      RUNNING_SUM(SUM([Sheet1 (Max_Spend.xlsx)].[Spend Monthly Max]))-RUNNING_SUM(SUM([Spend]))/DAY([DateStamp])


      Cam anyone help?