[NeilR113 Contributions: 0Level 1☆]

Hi all,

I’m experiencing a puzzling problem with the results of a saved search I’ve created. The search is intended to show any of our inventory items where the quantity available is less than 20 pieces. This bit works fine. The problem is that I want to sort the result in in descending order – i.e. starting wih the items where we have the fewest pieces on hand – the results are scheduled to be emailed to a group of senior managers each day so it helps to have the items of most concern at the top of the list.

The problem is the sorting lists any with a zero value at the end, not the start.

Any ideas gratefully received.

Neil.
This is a cached copy. Click here to see the original post.

[k_dunc Contributions: 0Level 1☆]

Hi Neil, I haven’t verified a similar sort in any of my accounts to see if I’m getting similar results, but just a thought if that’s clearly the way it is, you could add a Formula Results column and use something like a DECODE to change your numeric values to a letter. E.g, where Quantity Available = 0, DECODE it to ‘A’; 1 to ‘B’; 2 to ‘C’ etc., then sort on this column. That might work for you perhaps?

---

NeilR113 replied on 05/24/2016, 07:27 AM: Thanks Kirk, I’ll give that a try.

[egrubaugh Contributions: 0Level 1☆]

Do the results with zero value actually show as zeros? Or are they just empty cells?

---

NeilR113 replied on 05/24/2016, 07:32 AM: Hi Eric, yes the zeros are displayed.

[Dew Contributions: 0Level 1☆]

Instead of using the field “Available” in the results, try using a Formula (Numeric) of NVL({quantityavailable},0) , set a Custom Label of “Available”, then sort on Formula (Numeric).

---

k_dunc replied on 05/26/2016, 04:02 PM: Hi Dew, only issue I have with this is that Neil already told us that "the zeros are displayed". If they are displayed, then they won’t have a NULL value, so I’m guessing the NVL won’t do anything. Cheers.

[Author]

Posts