Netsuite Tragic
05/03/2022, 9:44 AMCASE
WHEN COUNT(DISTINCT CASE WHEN {transaction.trandate} > LAST_DAY(ADD_MONTHS({today}, -14)) AND {transaction.trandate} <= LAST_DAY(ADD_MONTHS({today}, -1)) THEN CASE WHEN {transaction.type}='Invoice' THEN {transaction.number} ELSE NULL END ELSE NULL END)>35 THEN 7 ELSE 90 END + {lastorderdate}
George McMullen
05/03/2022, 10:50 AM{lastorderdate}
like MIN({lastorderdate})
• Change COUNT(
to COUNT/*comment*/(
{lastorderdate}
that you could fix with NVL()
Netsuite Tragic
05/03/2022, 9:06 PM