< jcribb> `CASE WHEN transaction mainline = THEN NVL transac NetSuite Professionals #suiteanalytics

<@U4G32RNUV> `CASE WHEN {transaction.mainline} = '...

karlenigma

02/06/2018, 4:40 PM

@jcribb

CASE WHEN {transaction.mainline} = '*' THEN NVL({transaction.netamountnotax},0) ELSE 0 END

Works no issues.