Grouping

[#1]

hi

i have  one   filed  like    Data:

                                     0-5

                                     5-10

                                    10-15

                                    20-25

                                   25-30

                                   30- 35

];

my output like     0-15  only

[kumarnatarajan · Accepted solution]

Hi,

Use this dimension or script

Ex: =if(SubField(Range,'-',2)<=15,Dual('0-15',Range)) .

Find the attached file

[#3]

Hi ,

   Please use the below code in the where clause while loading the table.

Where   (SubField(Data,'-',1)>=0) and (SubField(Data,'-',2)<=15);

Regards

Yusuf

[#4]

Thanks