4 Replies Latest reply on Mar 31, 2016 2:02 PM by Łukasz Majewski

    Calculation won't total

    Gregg Hirshberg

      Unfortunately, I can't share the data that I'm using.


      I've created a calculation, IF [WO per Store] > WINDOW_AVG([WO per Store]) then 1 else 0 END so that I can count when a location has more than the average, and I want to view how many locations in total are above the average. But when I put this in a table, all the other fields total, but this ends with 0, even though the table above will have values. I hope I've explained it well. All I can provide is a screenshot.


      Thanks in advance.