4 Replies Latest reply on Oct 16, 2018 2:12 PM by Hunter Maxfield

    Avg Price - Cannot mix aggregate and non-aggregate comparisons or results in ‘IF’ expressions

    Julianne Jochym

      I have a dashboard where I have [Total List Price] and [Total Tickets] where I am calculating the average cost by sum[Total List Price]/sum[Total Tickets].

       

      This data is then broken down by department and by date. What I am trying to create is a chart showing the average price for both today and yesterday by department, in addition to the change in average. When I do this I receive the "Cannot mix aggregate and non-aggregate comparisons or results in 'IF' expressions. I've read several articles talking about LOD and adding ATTR() to the calculations, but I just can't seem to make it work correctly for my data.

       

      Attached is a packaged workbook. Any help would be greatly appreciated!