Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Hi @User12321 ,
Maybe this:
Sum( {< Account = {'4000'} >} if(Amount <0,Amount*-1,Amount) )
I hope it can help.
Best Regards
Andrea
Hi @User12321 ,
Maybe this:
Sum( {< Account = {'4000'} >} if(Amount <0,Amount*-1,Amount) )
I hope it can help.
Best Regards
Andrea
Try it with: Sum({<Account={'4000'}>} fabs(Amount))
- Marcus