Jump to content
Salesforce and other SMB Solutions are coming soon. ×

script or calculation for end of the month count


Recommended Posts

I was wondering if there is a script that will input the total monthly count for a particular month only, I want to be able to use it for every month.


What I have now is a total count for the week, which works fine, but the running count continues even after the month ends and I want it to stop at the end of the month and restart the count the next month.


I'm really terrible at scripts and worse with calculations, any help would be fantastic.

Link to comment
Share on other sites

What I have now is just summary field in a table and it is just a running count of the subtotal, I have a running count for each week but I want to be able to restart the count every month so it will reset to zero.


Any help would be fantastic.



Link to comment
Share on other sites

You'll need a calc to evaluate which month the record is from. Then you can summarize based on that:


Year_Month (calculation, text result) = year (date) & " " & month(date)


Having the year in there helps if the found set spans multiple years.


I'm not sure how well combining this will work with breakdowns by Week. The first and last week of most months are going to have partial weeks, probably giving smaller totals than full weeks. You might find yourself adding the last week week from one month to the first week of the next to get a meaningful number.

Link to comment
Share on other sites

This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...

Important Information

Terms of Use