This topic contains 2 replies, has 0 voices, and was last updated by anton8359 6 years, 10 months ago.
-
Posts
-
anton8359- Contributions: 0
- Level 1
- ☆
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- Contributions: 0
- Level 1
- ☆
When you used the case when function, what did you set as result?
-
anton8359- Contributions: 0
- Level 1
- ☆
Formula numeric // sum
You must be logged in to reply to this topic.