4 Replies Latest reply: Jun 4, 2017 6:50 AM by PAUL YEO RSS

    How to make my list box display <390 ?

    PAUL YEO

      Hi All

       

      I try to make my horz bar shorter. So i write the script below , But the issue is <390 and >420 does not appear . not sure where i did wrong ? Hope some one can advise me. ( pls take note that i have 2 list box , correct one can display but wrong one cannot display).

       

       

      =IF([aging_ar_class]='1-30','<30',

       

      IF([aging_ar_class]='31-60','<60',

      IF([aging_ar_class]='61-90','<90',

      IF([aging_ar_class]='91-120','<120',

      IF([aging_ar_class]='121-150','<150',

      IF([aging_ar_class]='121-150','<180',

      IF([aging_ar_class]='181-210','<210',

      IF([aging_ar_class]='210-240','<240',

      IF([aging_ar_class]='241-270','<270',

      IF([aging_ar_class]='271-300','<300',

      IF([aging_ar_class]='301-330','<330',

      IF([aging_ar_class]='331-360','<360',

      IF([aging_ar_class]='361-390','<390',

      IF([aging_ar_class]='391-420','<420'

      ))))))))))))))