How to do this ?

Hi all,

I’m working in Nav 5.0 Sp1 (native).

We always use SETFILTER or SETRANGE to filter actual data we want. But if we can’t find the actual data than how can we get the set of approximately same data.


I just want to filter the Set of data 99…100

Asking value is 99.99

Table Data




I think I have to write extra code to get the same.


This will depend on the tolerenance needed - you could filter from 99…101 for example.

Hi DaveT,

Thx for your reply.

I agree with you.

Yeap I have write extra code for the purpose.