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

image.png

Hey Everyone i need some help regarding saved search formula numeric. I am doing some calculations for customer on opportunity record, I need that column sum on main summary level. the formula numeric column sum and getting errors using summary type. Please kindly review this and help me out, I am not good at formulas.
Thanks

SUM needs a parenthesis around what you are summing. Like this SUM(xxxxxxx)

Also you need a summary function around all your variables of your equation. So add MAX() around your days open and nvl({amount})

(nvl({amount},0) / (SUM /* comment */ ({amount}) OVER(PARTITION BY {name} ORDER BY {name}))) * nvl({daysopen},0) using this now

when i use Maximum summary type it is giving error

otherwise without summary it is working fine

I basically want sum/total of amount and formula numeric sum/total of column on summary level