Exclude Negative Numbers from an expression on KPI

[JASalinas]

Hi my friends I have a KPI and the Expression Dimension i wrote this:

Sum({<[Account]={"138*", "322*", "338*", "A*", "ER*", "ET*", "R*"}>}(Amount)) Here i have amounts positives and amounts negatives but only want the sum of the amounts positives please!.

Thank you very much

Regards

JA Salinas

[Lisa_P]

Add that as another condition in set analysis:
Sum({<[Account]={"138*", "322*", "338*", "A*", "ER*", "ET*", "R*"}, Amount={">0"}>}(Amount)) 

[JASalinas]

Hi Lisa thank you for you answer

I tried to do that and it didn't work, i need Exclude the Amount Negative, i dont know if can to do from Script Editor... if i have a Pivot Table show me this

Thank you again

[JASalinas · Accepted solution]

Aquí la respuesta... el FUND no lo tomen en cuenta porque es una dimensión de nuestra contabilidad.

FABS(Sum({<[ACCNT_CODE]={"=Aggr(Sum([AMOUNT]),ACCNT_CODE)<0"}> - (1-$<[ACCNT_CODE]={"12*", "13*", "14*","32*", "33*", "34*","A*", "E*", "R*"}>) - <[FUND]={"20"}>}[AMOUNT]))