Range Expression in Application

[MalcolmCICWF]

I have some data displayed in an application and one of the fields is Days Delinquent, These days range from 0-100. Does anyone have experience with an expression so that I could select from this field 0-31, 32-61, and 62-100 instead of all the days shown separately?

[MayilVahanan]

Hi,

     Try this,

     In script, Use like this,

     Load * , if([Days Delinquent] >=0 and [Days Delinquent] < 32 , '0-31', if([Days Delinquent] >=32 and [Days Delinquent] < 62, '32-61', '62-100')) as DateRange from tablename;

Hope it helps

[nagaiank · Accepted solution]

Add a listbox with the expression

If([Days Delinquent] <= 31,'0-31',if([Days Delinquent] <= 61,'32-61','62-100'))

Hope this helps