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?