5 Replies Latest reply on Jun 7, 2016 1:46 AM by Mahfooj Khan

    Cannot solve aggregation & non-aggregated fields problem.

    Ray Mullins

      Hi all,

      Would greatly appreciate the help here, the below calculation is giving me the classic "cannot mix aggregated and non-aggregated fields" error message.

       

       

      Gross Profit % is an aggregated field i.e. SUM (Gross Profit) / SUM (Total Sales) and cannot be calculated any other way so I am happy with this part.

       

      InReportQuarter? is a dimension and is the issue here, its calculated as follows:

       

      Where Report Quarter is a date parameter used to flick between different periods.

       

      How to I aggregate the second screen shot above? I have tried everything!!

       

      Thanks,

       

      Ray