Sum only positive values or Flag

[JASalinas]

Hi Friends, I have the next Set...

(sum({<YearPeriod = {"$(=Year(DatePeriod))"}, MonthNumPeriod = {">= {'1'} <=$(=max(MonthNumPeriod))"}, MonthPeriod=, [FUND]={"10*"}, ACCNT_CODE={"12*", "13*", "14", "32*", "33*", "34*", "36*", "A*", "C*", "E*", "R*"}>}[AMOUNT])
+ (sum({<YearPeriod = {">=1844 <=$(=Year(DatePeriod)-1)"}, MonthNumPeriod = {">=1<=12"}, MonthPeriod=, [FUND]={"10*"}, ACCNT_CODE={"12*", "13*", "14", "32*", "33*", "34*", "36*", "A*", "C*", "E*", "R*"}>}[AMOUNT])))

AND

= /***** Caja y Equivalente de Efectivo *****/
if((sum({<YearPeriod = {"$(=Year(DatePeriod))"}, MonthNumPeriod = {">= {'1'} <=$(=max(MonthNumPeriod))"}, MonthPeriod=, [FUND]={"10*"}, ACCNT_CODE={"12*", "13*", "14", "32*", "33*", "34*", "36*", "A*", "C*", "E*", "R*"}>}[AMOUNT])
+ (sum({<YearPeriod = {">=1844 <=$(=Year(DatePeriod)-1)"}, MonthNumPeriod = {">=1<=12"}, MonthPeriod=, [FUND]={"10*"}, ACCNT_CODE={"12*", "13*", "14", "32*", "33*", "34*", "36*", "A*", "C*", "E*", "R*"}>}[AMOUNT]))) > 0.00, 'C', 'D') and  create the next table..

I want to sum only values positives or Only flag values D...

thanks in advance

[Benoit_C · Accepted solution]

Hi @JASalinas,

If you want to sum only positive values or only values with the flag ‘D’, you can try adding a condition to your set analysis expression to only include those values. For example, to sum only positive values, you can add a condition like AMOUNT={">0"} to your set analysis expression. To sum only values with the flag ‘D’, you can add a condition like FLAG={"D"} to your set analysis expression, where FLAG is the name of the field that contains the flag values.

Regards,
Benoit