7 Replies Latest reply: Mar 31, 2017 10:50 AM by Shahbaz Khan Mohammed RSS

    simple app table export different

    Robert Winkel

      I am having trouble with a APP.

      If I add a KPI and filter it down to one month the total is higher than what it is when I export report and add the column up and it does not match?

      In excel 169,748 rows and it should have 174,521 rows.

      on the latest version of sense.

       

      LIB CONNECT TO 'pharmoresql production (pharmore_rwinkel)';

      LOAD Billed,
          FacID,
          RxNo,
           DispenseDt,
          NDC,
          Qty,
          MOP,
          BillAmt,
          InvoiceGrp,
          DrugLabelName,
          IsACopay,
          OtherMOP;
      SQL SELECT Billed,
          FacID,
          RxNo,
           DispenseDt,
          NDC,
          Qty,
          MOP,
          BillAmt,
          InvoiceGrp,
          DrugLabelName,
          IsACopay,
          OtherMOP
      FROM FwReports.dbo.Billing

      Where Billed >= '2017-01-01 00:00:00';