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!!