Saved Search. Summary type of Maximum. FLOOR(ROUN...
# suiteanalyticsm
Mike
04/23/2019, 3:35 PMSaved Search. Summary type of Maximum. FLOOR(ROUND(SUM({amount})/(*50000*/4),2)/.05)*.05 works but FLOOR(ROUND(SUM({amount})/(*{department.goal}*/4),2)/.05)*.05 doesn't work. It seems like NetSuite doesn't like having the join and the SUM function in the same formula - but I am not sure why... Any suggestions?
k
KevinJ of Kansas
04/23/2019, 3:38 PMYou need a summary type on your bold result
👍 2
KevinJ of Kansas
04/23/2019, 3:39 PMAlso try breaking that formula up into chunks... you have a ton of stuff going on.
m
Mike
04/23/2019, 3:40 PMYou mean break it up in a formatting sense?
Mike
04/23/2019, 3:42 PMThank you! Adding in MAX() to the bold term fixed the issue!
k
KevinJ of Kansas
04/23/2019, 3:46 PMWell, you've got other potential issues - make sure that department.goal can't ever be 0.
KevinJ of Kansas
04/23/2019, 3:47 PMor you'll need to insert an max(nvl({department.goal},1))/stuff)
m
Mike
04/23/2019, 10:22 PMMakes sense, thank you for the help!