so `CASE WHEN to char custevent create time MM = to char tod NetSuite Professionals #general

so `CASE WHEN to_char({custevent_create_time}, 'MM...

Kevin McKee

07/12/2019, 5:47 PM

CASE WHEN to_char({custevent_create_time}, 'MM') = to_char({today}, 'MM') THEN COUNT({internalid}) ELSE 0 END

battk

07/12/2019, 5:52 PM

try using the

Count

(or the

Sum

) summary type

3 Views