Help with Set Analysis

[User12321]

Hello,

I have 2 fields, Account and Amount.

I want to sum up the value in the amount field such that

1. If the value is negative, I need to convert it to positive first before summing up.

2. I only need to sum up for Account with value = 4000.

Any suggestion please.

Thank you!

[agigliotti · Accepted solution]

Hi @User12321 ,

Maybe this:

Sum( {< Account = {'4000'} >} if(Amount <0,Amount*-1,Amount) )

I hope it can help.

Best Regards

Andrea

[marcus_sommer · Accepted solution]

Try it with: Sum({<Account={'4000'}>} fabs(Amount))

- Marcus