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

you will have to restructure the saved search to have the sum statements be around the case