Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
Help with elapsed weekdays combined with simple case statement
I have two formulas that work correctly independently. One for elapsed weekdays between to date fields and another that replaces zero value from a formula with .5. I want to combine the two so the second formula executes when the value of the first formula is not zero. I want to place it where the “99” currently is. I have tried multiple times but either I can’t get the parens correct or ??. Here are the two statements:
1)…CASE WHEN {closed} - {date} =0 THEN .5 ELSE 99 End
2)…TRUNC((TRUNC({closed})-TRUNC({DATE}))/7)*5 + MOD(TRUNC({closed})-TRUNC({DATE}),7) - CASE WHEN TO_NUMBER(TO_CHAR(TRUNC({closed}),'D')) < TO_NUMBER(TO_CHAR({DATE},'D')) THEN 2 ELSE 0 END
0