i’m just trying to adapt the

DECODE({item}, 'Item XXX', {quantity}, 0)

code that i use on a saved transaction search to this new saved item search but not having the luck i was hoping for

you might be able to do it without doing decode

any ideas how? 🙂

group by the

Name

(or

Internal Id

) column and sum by

Transaction : Quantity

definitely super close to what i’m after. i also want to list items that have not been purchased with a “0” in the transaction quantity column fingers crossed

use NVL

something like

NVL({transaction.quantity}, {name})

?

that extremely weird and wont sum

ok am trying

NVL({transaction.quantity}, '0')

and getting the same result as previous which is just listing the items the customer has been invoiced for rather than all items

what are your filter criteria

simply ‘transaction : type = invoice’ and then i’ve got a filter to select the customer’s name

your filter on the customer will limit your results to items that have transactions belonging to that customer

hmm damn, was hoping to list items even if the quantity = 0

its not that the quantity is 0

ultimately this was to be configured as sublist on the sales order form so users can easily see which quantity = 0

its that there isn't a join row that matches your filter

yeah i figure if i can’t set the filter to the customer name while testing a saved search it just can’t work as a sublist either which relies on the filter

Why not just do saved search fields?

interesting, not a bad idea shall try. thanks!