2 Replies Latest reply on Nov 15, 2012 1:34 PM by Hilary Knights

    Calculations

    Hilary Knights

      How do you create a calculated field that allows you to pull out the the average revenue for a specific set of months in a given year. The average revenue is already an aggregated calculated field.

      we have done the following:

       

      Case year(date_month) when 2010 then average_revenue else 0 end.

       

      We keep getting the error cannot mix aggregated with non-aggregated values.