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

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

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?

Hi Mario,

Beck

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

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