6 Replies Latest reply: Mar 14, 2018 6:58 PM by David Forest RSS

    KPI and Bar Chart Total not matching

    Prashant Sancheti

      I am having KPI having following condition

       

      KPI:

       

      if (sum([Quantity]) <> 0,

       

      if (Sum([DailyQuantitySales]) <> 0,


      sum([DailySales]) - sum([DailyVarSales]),

       

      sum([DailySales])

      )

      ,0)



      Bar Chart :  Region as dimension


      Measure:



      if (sum([Quantity]) <> 0,

       

      if (Sum([DailyQuantitySales]) <> 0,


      sum({<[Region] ={"=Sum([margin])>=0"}+{"=Sum([margin])<0"} >}[DailySales]) - sum({<[Region] ={"=Sum([margin])>=0"}+{"=Sum([margin])<0"} >}[DailyVarSales]),

       

      sum({<[Region] ={"=Sum([margin])>=0"}+{"=Sum([margin])<0"} >}[DailySales])

      )

      ,0)



      What could be the reason for getting total of KPI is not matching with total of Bar chart