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

I'm trying to subtract a field from a case when statement with a sum summary type on it in a SS, any tips? Thank you!

essentially I need {field}-SUM(case statement)
seems simple, but I keep running into errors or incorrect values

Try adding some summary types to that {field} as well. I typically use MIN or MAX. So try MAX({field}) assuming the field's value is constant within the record if there are multiple lines like transaction lines

Thank you!!! that worked exactly as I needed