In today’s NetSuite guide, we will share a saved search showcasing how to get the number of weekdays in a given month. This saved search can help in determining how many weekdays in a month.
This NetSuite saved search is beneficial for companies operating on weekdays only, and want to see their monthly sales in a more concise manner – a daily sales report. The desired formula is to divide the sales quantity/amount by the number of days they are operational in a given month.
1. Create a Transaction Saved Search with the following Standard Criteria:
2. Set the following in the Results tab:
| Field | Summary Type | Function | Formula | Summary Label |
| Date | Group | Month | Month | |
| Amount | Sum | Amount | ||
| Formula (Numeric) | Group | to_char(last_day(trunc({trandate})),'DD')-((trunc(last_day({trandate}),'IW')-trunc(trunc({trandate},'MONTH'),'IW'))/7*2)-(decode(to_char(last_day(trunc({trandate})),'D'),1,2,7,1,0))+(decode(to_char(trunc({trandate},'MONTH'),'D'),1,1,0)) | No. of Days | |
| Formula (Currency) | Sum | {amount}/(to_char(last_day(trunc({trandate})),'DD')-((trunc(last_day({trandate}),'IW')-trunc(trunc({trandate},'MONTH'),'IW'))/7*2)-(decode(to_char(last_day(trunc({trandate})),'D'),1,2,7,1,0))+(decode(to_char(trunc({trandate},'MONTH'),'D'),1,1,0))) | Sales per Day |
Note: You may add additional fields that you want to see whenever you drill down on the Saved Search.
As a highly accredited NetSuite Solution Provider, ScaleNorth is well positioned to help you with the full scope of your NetSuite customization needs. If you require more NetSuite assistance, contact ScaleNorth today.
Kouji is a seasoned professional in NetSuite Consulting, he brings a wealth of experience as an Ex-Director of Customer Support at NetSuite and Airbase. A Certified Public Accountant, his unique blend of financial expertise and technical savvy enables him to navigate complex challenges and provide innovative solutions. With a track record of leadership and a deep understanding of NetSuite intricacies, Kouji delivers seamless customer support strategies.
