15 Replies Latest reply: Apr 23, 2014 7:59 AM by Phil Colbert RSS

    Class & Age Function

    Phil 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