How to do this ?

Business Central/NAV Developers Forum
1

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.

Scenario

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

Asking value is 99.99

Table Data

99

100

120

2

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

3

Hi,

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

4

Hi DaveT,

Thx for your reply.

I agree with you.

Yeap I have write extra code for the purpose.