0 Replies Latest reply: Sep 13, 2016 11:31 AM by Troy Strachan RSS

    RangeAvg combined with RangeSum?

    Troy Strachan

      Hey everyone,

      This has been bugging me for a while, and I can't seem to get the correct numbers.

      We use Microsoft Dynamics Nav which keeps track of all our transactions, which is great, but it also means that we cannot get end of day values easily. So when I use a range avg I'm getting an average of the transactions.

      So what I'm trying to do is get an average of this rangesum function:

      RangeSum (above(sum(Actual),0,RowNo()))

       

      What I've tried (That I can remember):

      RangeAvg (above(sum(Actual),0,RowNo())) --> average of the transactions.

      avg(RangeSum (above(sum(Actual),0,RowNo()))) --> Qlik doesn't like it

       

      I have tried RangeAvg with a total aggr but I think I didn't get the correct syntax.

       

      Any help is GREATLY appreciated.

      This has been driving me bonkers.