

Creator III
2020-10-08
09:55 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Showing Negative only values in expression
Could you help me showing the negative amount in this expression?
If(Type = 'D', Sum({<FactType = {'T'}>}Amount)
, If(Type = 'C' AND GL = '1001', 'Show Negative Amount Only'
, Sum({<FactType = {'T'}>}Amount)))
Thank you. Much appreciated
595 Views
1 Solution
Accepted Solutions

MVP
2020-10-08
10:20 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@AH are you looking for ?
=sum({<Amount={"<0"},FactType = {'T'}>}Amount)
for example :
Regards,
Taoufiq ZARRA
"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "
(you can mark up to 3 "solutions") 😉
Taoufiq ZARRA
"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "
(you can mark up to 3 "solutions") 😉
2 Replies

MVP
2020-10-08
10:20 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@AH are you looking for ?
=sum({<Amount={"<0"},FactType = {'T'}>}Amount)
for example :
Regards,
Taoufiq ZARRA
"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "
(you can mark up to 3 "solutions") 😉
Taoufiq ZARRA
"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "
(you can mark up to 3 "solutions") 😉


Creator III
2020-10-08
01:53 PM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
That is the correct answer. Thanks for the help Taoufiq!
Much appreciated
558 Views
