Question on sorting for values 0-7, 8-30, 31-60, 61-100, >100 and null'-'

[thimma_paul]

if((Today() - LeadLastAssignmentDate) > 100, '>100',

  if((Today() - LeadLastAssignmentDate) >= 61, '61-100',

  if((Today() - LeadLastAssignmentDate) >= 31, '31-60',

  if((Today() - LeadLastAssignmentDate) >= 8, '8-30',

  if((Today() - LeadLastAssignmentDate) >= 0, '0-7',

  '-')))))

[thimma_paul]

How to sort values

[#3 · Accepted solution]

Hi,

Use Sort>>Expression

Put formula like this

If([Column_Name]='0-7',1, If([Column_Name]='8-30',2, If([Column_Name]='31-60',3,If([Column_Name]='61-100',4,If([Column_Name]='>100',5)))))

Regards,

KC

[#4]

Hi Thimma,

you might want to load this field as a dual, so the field has a text and underlying numeric for each value, you can then just sort by number on the field.

hope that helps

Joe

[henrybrinkmann]

Hi Thimma,

here an example:

=if((Today() - LeadLastAssignmentDate) > 100, Dual('>100', 1),

  if((Today() - LeadLastAssignmentDate) >= 61, Dual('61-100', 2),

  if((Today() - LeadLastAssignmentDate) >= 31, Dual('31-60', 3),

  if((Today() - LeadLastAssignmentDate) >= 8, Dual('8-30', 4),

  if((Today() - LeadLastAssignmentDate) >= 0, Dual('0-7', 5),

  Dual('-', 6))))))

it's like Joe wrote!

BR

Henry

[Anonymous]

Hi,

if(Floor(Interval(Today()-LeadLastAssignmentDate,'DD'))>100,'>100',

if(Floor(Interval(Today()-LeadLastAssignmentDate,'DD'))>=61 and Floor(Interval(Today()-LeadLastAssignmentDate,'DD'))<100,'61-100',

if(Floor(Interval(Today()-LeadLastAssignmentDate,'DD'))>=31 and Floor(Interval(Today()-LeadLastAssignmentDate,'DD'))<=60,'31-60',

if(Floor(Interval(Today()-LeadLastAssignmentDate,'DD'))>=8 and Floor(Interval(Today()-LeadLastAssignmentDate,'DD'))<=30,'8-30',

if(Floor(Interval(Today()-LeadLastAssignmentDate,'DD'))>=0 and Floor(Interval(Today()-LeadLastAssignmentDate,'DD'))<=7,'8-7',

'-')))))

Regards.

Jannet