Grouping based an date ranges

SpeedRacer · Feb 22, 2017

I have a formula if {Fish.Date} in Date (2016, 08, 01) to Date (2016, 10, 31) then "1st Quarter" else
if {Fish.Date} in Date (2016, 11, 01) to Date (2017, 01, 31) then "2nd Quarter" else
if {Fish.Date} in Date (2017, 02, 01) to Date (2017, 04, 30) then "3rd Quarter" else
if {Fish.Date} in Date (2017, 05, 01) to Date (2017, 07, 31) then "4th Quarter"
When i group, based on the this formula it doesn't always return the data as expected.
Most of the time i get
1st Quarter data data data
2nd Quarter data data data
3rd Quarter data data data

but sometimes it returns 2nd Quarter data data data
3rd Quarter data data data
1st Quarter data data data

or 2nd Quarter data data data
1st Quarter data data data
3rd Quarter data data data

Any Ideas.

BettyJ · Feb 22, 2017

Do you have any other groups above this group?

SpeedRacer · Feb 22, 2017

Yes, Group 1 is Farm, Group 2 Quarter

BettyJ · Feb 22, 2017

That's why - it first groups on Farm and then on Quarter.

I am not exactly sure how you need it, but maybe you can try to combine the groups the way you need by creating a formula like:

@CombinedGroup[tt]
@QuarterGroup &" "& {TABLE.YourFarmField][/tt]

Change QuarterGroup to the name of the formula you have listed in your first post.
Group by @CombinedGroup and delete the other two groups.

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Grouping based an date ranges

SpeedRacer

Programmer

BettyJ

Programmer

SpeedRacer

Programmer

BettyJ

Programmer

Similar threads

Part and Inventory Search

Sponsor