3 Replies Latest reply: Apr 29, 2015 8:24 PM by Sara Leslie RSS

    Rolling Date Bucket List Boxes

      Looking to create a list box that has four options.

       

      Less than 30 days

      Less than 60 days

      Less than 90 days

      More than 90 days

       

      However everything I have done so far has made 30 day buckets instead. In other words:

      0 to 30 days

      31 - 60 days

      61 - 90 days

      90+ days

       

      That wont work for what I need.

       

      What I tried:

       

      =AGGR(

       

       

      If(WO_Days_Difference >0 and WO_Days_Difference <31, '30 Days or Less',

      If(WO_Days_Difference >0 and WO_Days_Difference <61, '60 Days or Less',

      If(WO_Days_Difference >0 and WO_Days_Difference <91, '90 Days or Less',

      If(WO_Days_Difference >0 and WO_Days_Difference >90, '90 Days or More'))))

       

       

      , WO_Days_Difference)