How do I count the number of SO w/ backorders?
i can't find out backorder unless i set mainline = false.
and when i do that, then i can't count the number of sales order.
How do I count the number of item fulfillment???
no duplicate sales order though.
i need to group {createdfrom} then count it.
COUNT(GROUP(CASE WHEN {type}='Item Fulfillment' AND {mainline}='*' THEN {createdfrom} ELSE null END))
i tried this, but it didn't work
GROUP is giving an invalid expression