Hi All,
I am trying to do the following beast mode operation:
COUNT(DISTINCT (CASE when `ord_date` < CURDATE()-1 then CONCAT(`sales_no`,`part_no`) end ))
The expectation is the distinct combination of sales_no and part_no ..But I am not getting that..Can you please help me here..
Thanks,
Arun