CASE WHEN daysopen gt 31 OR daysopen lt 61 THEN amount ELSE NetSuite Professionals #suitescript

CASE WHEN {daysopen} > 31 OR {daysopen} < 61...

DonkeyBot

11/18/2020, 8:53 AM

CASE WHEN {daysopen} > 31 OR {daysopen} < 61 THEN {amount} ELSE 0 END

PNJ

11/18/2020, 9:39 AM

CASE WHEN {daysopen} > 31 AND {daysopen} < 61 THEN {amount} ELSE 0 END

PNJ

11/18/2020, 9:39 AM

Needed an AND instead of OR

DonkeyBot

11/18/2020, 9:44 AM

Thanks