• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 341
  • Last Modified:

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!

1 Solution
Try this

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

Create a group on the formula

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

Spudmcc (Andy)
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.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now