Hi I was wondering if I can add a new range in "is in this period" in

[jbpr]

Hi I was wondering if I can add a new range in "is in this period" in group option, now I have these options:

aged0to30days
aged31to60days
aged61to90days
over90days

I want add if is posible:
aged91to120days
aged121to150days
aged151to180days

 

[synapsevampire]

You can write your own formula for a group, but not edit the existing options.

For instance:

if currentdate-{table.date} < 31 then
30
else
if currentdate-{table.date} < 61 then
60
else
if currentdate-{table.date} < 91 then
90
else
if currentdate-{table.date} < 121 then
120
else
if currentdate-{table.date} > 120 then
9999

you can add as many periods as you need.

Choose this as you group field and it will group the values for you. You can base the display on the value returned by this field as well.

-k

 

[jbpr]

Thank you...its work for me...