15 Replies Latest reply: Apr 23, 2014 7:59 AM by phillip colbert RSS

    Class & Age Function

    phillip colbert

      Morning all!

       

      i use the Class and Age functions to create age bands in a table for employee date of births i.e.

       

      =Class(Age('$(vMyDate)',date_of_birth),5,'Age Band' )  -- where vMyDate is a variable storing todays date

       

      Now this displays perfectly as you'd imagine, as a list of staff by age bands. The problem that i have is that when an age band is selected and therefore the results restricted you cant deselect it to go back to the full list.

       

      i guess this is because the user isn't actually selecting an age band, but what is essentially a function.

       

      does anyone know of any workarounds to make it de-selectable?

       

      thanks in advance