How to make my list box display <390 ?

[paulyeo11]

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'

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

[paulyeo11]

Enclosed my QVF

[vinieme12]

why not use Pick(Match( instead ?

example

Pick( Match([aging_ar_class],'1-30', '31-60','61-90','91-120') , '<30','<60','<90','<120')

[paulyeo11]

Hi Vineeth

I use your approach , it is very much simple , but it still does not able to recode arging from 361-390. why ?

Paul

[paulyeo11]

Hi All

I have try to record the raw data to new field by using the Load script and it work fine now.

Paul Yeo

DIrector

TDS Technology (S) P/L

Whatsapp +65 9326 1804

www.tdstech.com<http://www.tdstech.com>