Contributor
2023-05-30
10:23 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Making visible only negative values from a table
I have a table of amounts and I need to filter it so that it only shows credits or negative numbers. When I use a if statement, it nulls or grays out the cells in the "amount" column that is a positive but does not hide the entire row. I've also tried suppress null values and 0 values option but it doesn't work
I'm trying to use this set expression to create the filter but I'm getting an error: "Error in expression: ')' expected."
if($amount)<0, Sum(amount),0)
1,020 Views
MVP
2023-05-31
07:41 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try this
=if(amount < 0, amount)
994 Views
Contributor
2023-05-31
08:32 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
That just grays out the cells containing positive values in that column. I'm still able to see the rows.
992 Views