Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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]='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'
))))))))))))))
Enclosed my QVF
why not use Pick(Match( instead ?
example
Pick( Match([aging_ar_class],'1-30', '31-60','61-90','91-120') , '<30','<60','<90','<120')
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
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>