[anton8359]

Hello,

Wondering if anyone can help me out. I created a custom field in items to categorize items by different types .. I am wondering if there is a way I can count the total unique SO's that contain items (one or more) of a particular category from the custom field ..

Ultimate purpose is to divide the count from total transactions to create a ratio % …

Right now can use CASE WHEN's but am only able to pull total lines rather than just getting a count of transactions (Sales Orders) which contain a line with particular item

IE lets say Item AA is what I'm looking for if SO 1 has Items AA AA AB AC , SO 2 has Items AB and AC .. then I'd like to be able to have a column which results in AA Transactions (1) ; Total Transactions (2) ; Ratio =50%
This is a cached copy. Click here to see the original post.

[Jhelver Layderos]

When you used the case when function, what did you set as result?

[anton8359]

Formula numeric // sum

[Author]

Posts