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

SUM(case when{type} = 'Work Order Issue' then {quantity} else 0 end) -SUM(case when{type} = 'Work Order Close' then -{quantity} else 0 end)

is this formula correct? it is not adding for some reason

This is from the SuiteAnswer
• Summary Type | Maximum
• Field | Formula (Numeric)
• Formula | SUM(case when {type} = 'Work Order Issue' then {quantity} else 0 end) - SUM(case when {type} = 'Work Order Close' then -{quantity} else 0 end)
• Formula (Numeric) | not equal to
• Vale | 0


i'd probably just do this

`sum(decode ({type},'Work Order Issue',nvl({quantity},0),'Work Order Close',-nvl({quantity},0),0))`