Comments
-
Sorry, i it doesn't work. I changed the beast mode to as below. CASE WHEN SUM(CASE WHEN `Region_TWC` IN ('NAM','EUROPE','PACIFIC','JAPAN','KOREA','GCA','SEA') AND `PO Type` IN ('Sample','Demo','SF','M0','M1') AND `Meet FOB DL_AR`= 'Meet AR DL' THEN `Ordered unit` END) >= SUM(DISTINCT `PAR in PQ`) THEN SUM(DISTINCT `PAR in…