SUM not working in KPI

[Pablo_Vidal_1987]

hi everyone,

i have a problem with a formula for a KPI, because is not showing the SUM:

if(sum({<NUM_PERIODO={$(vNumPeriodoAnt)},COD_TIP_PRD={'1','4'}>} COLOC + MTO_CTGTE) = 0 and
sum({<NUM_PERIODO={$(vMaxPeriodoSel)},COD_TIP_PRD={'1','4'}>} COLOC + MTO_CTGTE) > 0,
sum({<NUM_PERIODO={$(vMaxPeriodoSel)},COD_TIP_PRD={'1','4'},COD_TIP_EVL_FIN={'I'}>} PROV)-
sum({<NUM_PERIODO={$(vNumPeriodoAnt)},COD_TIP_PRD={'1','4'},COD_TIP_EVL_FIN={'I'}>} PROV),0)/1000000

i don´t know what i´m doing wrong, because this same formula works fine in a table:

PLEASE HELP,

thank you. 

[vinieme12 · Accepted solution]

Try below

SUM( AGGR(  if(sum({<NUM_PERIODO={$(vNumPeriodoAnt)},COD_TIP_PRD={'1','4'}>} COLOC + MTO_CTGTE) = 0 and
sum({<NUM_PERIODO={$(vMaxPeriodoSel)},COD_TIP_PRD={'1','4'}>} COLOC + MTO_CTGTE) > 0,
sum({<NUM_PERIODO={$(vMaxPeriodoSel)},COD_TIP_PRD={'1','4'},COD_TIP_EVL_FIN={'I'}>} PROV)-
sum({<NUM_PERIODO={$(vNumPeriodoAnt)},COD_TIP_PRD={'1','4'},COD_TIP_EVL_FIN={'I'}>} PROV),0)

, RUT) )

RUT <-- aggregate by your table dimension

[Pablo_Vidal_1987]

Thanks a lot mate, works perfectly