Current liabilities KPI

[JASalinas]

Hi My Friends... I have the next Expression in Table or KPI Graphics...

=num((Sum(Aggr(if(sum({<[ACCNT_CODE]={"32*","33*","34*","12*","13*","14*","132*","133*","134*","135*","136*","137*","138*", "A*", "E*", "R*"}, [FUND]={"10*"}, [YearPeriod]=, [MonthYearPeriod]={"<=$(=max(MonthYearPeriod))"}, [MonthPeriod]=>}[AMOUNT]) >= '0.000',
sum({<[ACCNT_CODE]={"32*","33*","34*","12*","13*","14*","132*","133*","134*","135*","136*","137*","138*", "A*", "E*", "R*"}, [FUND]={"10*"}, [YearPeriod]=, [MonthYearPeriod]={"<=$(=max(MonthYearPeriod))"}, [MonthPeriod]=>}[AMOUNT]),0),ACCNT_CODE))),'#,##0.00')

The result is as follows:

But In other Accounting Program the result is as follows:

It does not show me those two accounts because they had no movement in the current month,

I need you to show them to me even if they have no movements in that month

Thanks in advance!...

[JASalinas · Accepted solution]

Here the answer

(Sum({<[ACCNT_CODE]={"32*","33*","34*","12*","14*","132*","133*","134*","135*","136*","137*","138*", "A*", "E*", "R*"}, [YearPeriod] = {"$(=Year(DatePeriod))"}, [MonthNumPeriod] = {">= {'1'} <=$(=max(MonthNumPeriod))"}, [MonthPeriod]=>
+ <[ACCNT_CODE]={"32*","33*","34*","12*","14*","132*","133*","134*","135*","136*","137*","138*", "A*", "E*", "R*"}, [YearPeriod] = {">=2017 <=$(=Year(DatePeriod)-1)"}, [MonthNumPeriod] = {">=1<=12"}, [MonthPeriod]=>}
Aggr(if(sum({<[ACCNT_CODE]={"32*","33*","34*","12*","14*","132*","133*","134*","135*","136*","137*","138*", "A*", "E*", "R*"}, YearPeriod = {"$(=Year(DatePeriod))"}, MonthNumPeriod = {">= {'1'} <=$(=max(MonthNumPeriod))"}, [MonthPeriod]=>}[AMOUNT])
+ sum({<[ACCNT_CODE]={"32*","33*","34*","12*","14*","132*","133*","134*","135*","136*","137*","138*", "A*", "E*", "R*"}, [YearPeriod] = {">=1844 <=$(=Year(DatePeriod)-1)"}, [MonthNumPeriod] = {">=1<=12"}, [MonthPeriod]=>}[AMOUNT]) >0,
sum({<[ACCNT_CODE]={"32*","33*","34*","12*","14*","132*","133*","134*","135*","136*","137*","138*", "A*", "E*", "R*"}, [YearPeriod] = {"$(=Year(DatePeriod))"}, [MonthNumPeriod] = {">= {'1'} <=$(=max(MonthNumPeriod))"}, [MonthPeriod]=>}[AMOUNT])
+ sum({<[ACCNT_CODE]={"32*","33*","34*","12*","14*","132*","133*","134*","135*","136*","137*","138*", "A*", "E*", "R*"}, [YearPeriod] = {">=1844 <=$(=Year(DatePeriod)-1)"}, [MonthNumPeriod] = {">=1<=12"}, [MonthPeriod]=>}[AMOUNT]),0),ACCNT_CODE)))