1 Reply Latest reply on Apr 23, 2015 7:42 AM by John Huynh

    9.0 Level of Detail subtotal for average wrong?

    John Huynh

      Using the superstore sample dataset, I see that the overall average for state transactions is $29.

       

      For SUM, I have OK results with the new LOD feature.

       

      For AVG, I don't know if I'm doing it wrong, but the results look weird. I created "Profit per State AVG (LOD" like

      {FIXED [State]:avg([Profit])}

       

      And it's right at the State and City level, but at the grand total, it seems to just sum the averages..... Is this a bug? Or am I doing it wrong?

       

      LoD.png