Group by Number of Days

Hi Experts!

I have a very simple crosstab report that requires grouping by days.  The days are in the row field.  They go from 1-500 usually...can vary.  I want to group them every 15 records.  Days 1-15 would be in a group.  16-30 would be in a group etc.  Seems like it should be easy but I am banging my head against the wall.  

Any help would be greatly appreciated as always!

spudmcc
spudmccAsked:
Who is Participating?
 
mlmccConnect With a Mentor Commented:
Try this

Create a formula
 
    ({YourField} - 1) \ 15

Create a group on the formula

mlmcc
0
 
spudmccAuthor Commented:
Fantastic!  Thank you so much for the quick turnaround!  Appreciate it as always.  

Spudmcc (Andy)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.