3 Replies Latest reply: Jul 25, 2017 7:05 AM by Yaniv Ben Malka RSS

    Different total shown in KPI and Bar/Pie charts

    Yaniv Ben Malka

      I am experiencing a weird thing, which I hope anybody could explain.

       

      I am trying to use the same master measure for KPI and for Bar/Pie chart.

       

      This is the formula I'm using:

       

      count({<[TBLSupplierInovice.StatusCheck]={'NOGOOD'}>+<[TBLPaybale.IsCurrencyDiscrepancy]={">0"}>+<[TBLPaybale.IsSupplierDiscrepancy]={">0"}>+<[TBLSupplierInovice.IsPriceDiscrepancy]={">0"}>} distinct InvoiceNumber)

       

      I want to count invoice number distinctly for every line that complies with at least one of the conditions.

       

      When exporting the result to KPI object, I get a certain result.

      When exporting to Bar/Pie chart the total of all categories is different than KPI result.


      I tried many variations, sometimes the result I wish for is in KPI, and somtimes the result I wish for is in the chart.


      Another important note is that when I take only one condition, the results are fine.

      -Like this: count({<[TBLSupplierInovice.IsPriceDiscrepancy]={">0"}>} distinct InvoiceNumber)


      Anybody has a clue?