1 Reply Latest reply: Mar 18, 2018 2:38 PM by Bill Markham RSS

    Creating Aging Categories

    Michael Popa

      I have Support Case aging data but I need to put them in to aging categories (i.e. < 2days, 2 - 15 days, 15-30 days, 30-60, >60, etc.)

       

      I thought it would be this simple:

      =If([Age (Days)]<2,'<2', If([Age (Days)]<15,'2-15', If([Age (Days)]<30,'15-30', IF([Age (Days)]<60,'30-60', If([Age (Days)]>60,'>60'