7 Replies Latest reply: Oct 14, 2014 6:34 AM by Martin Mahler RSS

    sum function results are wrong

      Hi, I did a pivot table in excel:

       

      StorePO_numSum of linecost
      A123456456
      B123434573
      C123435747
      Total126776

       

      But when I did a straight table version of the excel pivot table in qlikview, the numbers do not tally.

       

      I tried using the formulas 'sum(linecost)' and 'aggr(sum(linecost),PO_num,Store)' but it does not work.

       

      Thanks.