Channels
accounting
administration
advancedpdf
announcements
arm
australia
beginners
beta-testers
bundles
case-management
content-alerts
crm-sfa
csvimports
data-privacy
defects
demandplanning
dev-ops
fixed-assets-mgmt
formulas
general
integrations
inventory
italy
jobs
manufacturing
marketing
migration-discussion
multibook
nspb
oneworld
order-to-cash
payroll
performance
procure-to-pay
projects
r-e-networks
random
releases
request-a-channel
scis
scripting
sdf
sfa
sitebuilder
spain
srp
suite-app
suite-billing
suite-people
suiteanalytics
suitebuilder
suitecommerce
suiteflow
suiteql
suitescript
suitetalkapi
suiteworld
taxes
training
upvote-enhancements
women-in-netsuite
Powered by
Title
k
KevinJ of Kansas
07/25/2019, 9:52 PM
it's when you are adding enough to cross 2 weekends that that formula gets stupid hard.
r
Ricardo
07/25/2019, 11:35 PM
you could possibly do a CASE(TRUNC(#ofdays/7))>=1 THEN SUM((TRUNC(#ofdays/7)*2),#ofdays) you'd get close anyway...
#general
Join Slack