On a transaction search i have the following formu...
# administration
t
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
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
t
Amazing, thank you!