Show KPI column Totals Function Sum

[JASalinas]

Hi my Friends, i have the next expression FABS(if(sum({<[ACCNT_CODE]={"12*", "13*", "14*","32*", "33*", "34*","A*", "E*", "R*"}, [FUND]={"10*"}, [YearPeriod]={"<=$(=Year(DatePeriod))"}, [MonthYearPeriod]={"<=$(=max(MonthYearPeriod))"},[MonthPeriod]=>}[AMOUNT])<0,
sum({<[ACCNT_CODE]={"12*", "13*", "14*","32*", "33*", "34*","A*", "E*", "R*"}, [FUND]={"10*"}, [YearPeriod]={"<=$(=Year(DatePeriod))"}, [MonthYearPeriod]={"<=$(=max(MonthYearPeriod))"},[MonthPeriod]=>}[AMOUNT]),0)) in the table, when i use Totals Function the sum is wright

But when I want to use a KPI the sum is wrong

I need your help please and thank you in advanced.

[ArnadoSandoval]

Hi @JASalinas 

The formula appearing in your screenshot contains the Aggr() function, while the one posted in this topic does not; as they are not the same expression, I do not expect to get the same result.

hth

[JASalinas]

No my friend, the first formula have //, I am doing test, the formula is wright in the post!...

[MayilVahanan · Accepted solution]

Hi @JASalinas 

You are using "Sum" functionality in the chart to achieve your result instead of Auto.

In order to achieve the same result in the KPI, you can try with 
Sum(Aggr(ur expression, ACCNT_CODE))

Hope it helps