This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

help!! I'm working on some reporting have the search figure out when there is no summary but as I'm trying to get a ratio calculated on a summary level I'm getting an error.. triple check the formula and can not find the error

CASE WHEN {title}='Engineering : Build Engineering' THEN
SUM(COALESCE
({custevent_estimatedworkl3av},0)*110-COALESCE
({custevent_estimatedworkl3av},0)*50)/SUM(NULLIF
(COALESCE
({custevent_estimatedworkl3av},0)*110,0)) WHEN {title}=
('Engineering : Drafting') THEN SUM(COALESCE
({custevent_estimatedworkl3av},0)*75-COALESCE
({custevent_estimatedworkl3av},0)*50)/SUM(NULLIF
(COALESCE
({custevent_estimatedworkl3av},0)*75,0)) ELSE 0
END

might seem daft because most people in this channel I'd guess are also in the suiteanalytics channel but may be worth posting this in that channel if you didn't figure it out. :wink: