2 Replies Latest reply: Jun 14, 2017 1:11 PM by Mario Rodrigues RSS

    How to show curve b (of the abc curve) in a kpi?

    Mario Rodrigues

      How to show curve b (of the abc curve) in a kpi?

        • Re: How to show curve b (of the abc curve) in a kpi?
          beck bakytbek

          Hi Mario,

           

          please give a screenshot of your extpected output

           

          Beck

            • Re: How to show curve b (of the abc curve) in a kpi?
              Mario Rodrigues

              Well, it's a simple thing to sum (value) only the products that belong to curve b .. of the curve abc ... I already have

              if (RangeSum(Above(

              Sum({$<COD={'1','3','12','13'}>} [VALUE]), 1, RowNo ()), Sum({$<COD={'1','3','12','13'}>} [VALUE]))/Sum({$<CD_FIL={'1','3','12','13'}>} TOTAL [VALUE])< 0.50, 'A',

              if (RangeSum(Above(

              Sum({$<COD={'1','3','12','13'}>} [VALUE]), 1, RowNo ()), Sum({$<COD={'1','3','12','13'}>} [VALUE]))/Sum({$<COD={'1','3','12','13'}>} TOTAL [VALUE])< 0.80, 'B',

              if (RangeSum(Above(

              Sum({$<COD={'1','3','12','13'}>} [VALUE]), 1, RowNo ()), Sum({$<COD={'1','3','12','13'}>} [VALUE]))/Sum({$<COD={'1','3','12','13'}>} TOTAL [VALUE])< 0.999999, 'C',

              '-')))

               

              But I would like to display in a SIMPLE KPI only the value of CURVE B