How to simplify my expression on search string ?

[paulyeo11]

Hi All

Now i use a button for filter Current Asset

On the action, i choose = select in field  :- field name i enter "Reporting Code"

On the search string i enter :-

(50010|50011|50016|50020|50021|50022|50012|50024|50028|50014|50029|50013|50025|50026|50030|50035|50040|50051|50043|50050|50092|50053|50055|50056|50057|50058|50059|50060|50065|50083|50075|50085|50090)

My question is it there any short cut where i can write >=50010 <= 50090 ? ( Since the number is running from 50010 till 50090. )

Paul

[#2]

try this

ValueLoop(50010,50090,1)

[paulyeo11]

Hi Sir

I try but it still not working. See the enclosed file.

[er_mohit]

try with equal sign

=' >=50010 & <= 50090'

but i works for me

click on button after doing it

see the attached file

[sushil353]

Valueloop and valuelist functions are used for calculated dimensions.

they cant be used as search string

[paulyeo11]

I try your advise , same it does not work.

[Sokkorn · Accepted solution]

Hi Paul,

This one seem to work

='>=' & 50001 & '<=' & 50090

Regards,

Sokkorn

[paulyeo11]

wonderful , it work now. many thank.