topic Re: Making visible only negative values from a table in App Development

Making visible only negative values from a table

yuvi — Wed, 31 May 2023 02:23:44 GMT

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)

Re: Making visible only negative values from a table

Chanty4u — Wed, 31 May 2023 11:41:17 GMT

Try this

=if(amount < 0, amount)

Re: Making visible only negative values from a table

yuvi — Wed, 31 May 2023 12:32:34 GMT

That just grays out the cells containing positive values in that column. I'm still able to see the rows.