Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
mario_ti
Creator
Creator

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

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

2 Replies
beck_bakytbek
Master
Master

Hi Mario,

please give a screenshot of your extpected output

Beck

mario_ti
Creator
Creator
Author

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