Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Paul,
This one seem to work
='>=' & 50001 & '<=' & 50090
Regards,
Sokkorn
try this
ValueLoop(50010,50090,1)
Hi Sir
I try but it still not working. See the enclosed file.
try with equal sign
=' >=50010 & <= 50090'
but i works for me
click on button after doing it
see the attached file
Valueloop and valuelist functions are used for calculated dimensions.
they cant be used as search string
I try your advise , same it does not work.
Hi Paul,
This one seem to work
='>=' & 50001 & '<=' & 50090
Regards,
Sokkorn
wonderful , it work now. many thank.