1 Reply Latest reply: Jan 18, 2018 2:53 AM by Yeo Poh sai RSS

    How to make field Month_n into list box with 4 selection for filter month ?

    Yeo Poh sai

      Hi All


      I have a field month_n


      if i click 0 , it will select current month.

      if i click -1 , it will select Next month.

      if i click -2 , it will select Next 2 month.

      if i click -9 , it will select Next 9 month.


      Now i like to make this become a list box.


      which have 4 choice :-


      if user select 0 , it will filter current month.

      if user select -1 , it will filter current till next month.

      if user select -2 , it will filter current till next 2 month.

      if user select -9 , it will filter current till next 9 month.


      Cacn some one share with me how to do it ?


      I assume some thing like below :-


      =IF([Month_n]<='0','0',


      IF([Month_n]<='-1','-1',


      IF([Month_n]<='-2','-2',


      IF([Month_n]<= '-9','-9'


      ))))


      But i don't know how to trigger month seelect.


      Paul Yeo









      Paul Yeo