On a transaction search i have the following formula as a result which is displaying amount fulfilled but unbilled nvl(ABS((nvl({quantitybilled},0) - nvl({quantityshiprecv},0)) * {rate}),0)
how can i exclude all results thats displaying a $0 value in this column?
r
rudler
05/04/2023, 2:17 PM
In your SS criteria, use a Formula (Numeric) with a case statement:
case when nvl(ABS((nvl({quantitybilled},0) - nvl({quantityshiprecv},0)) * {rate}),0) > 0 then 1 else 0 end