Filter in decimal field

hhhhhhhqat
hhhhhhhqat Member Posts: 111
edited 2014-03-26 in NAV/Navision Classic Client
Hi ..


i want to apply filter to decimal field with below criteria :


100.75
19.50
12.00
21.50
98.35
45.50


i want to filter for value ending with (0.50), the result ( 19.50 - 21.50 - 45.50 ) ...can we do it direct or need to write code.

i am planning if can't be direct from the field , need the code to be used in data port .

Comments

  • geordie
    geordie Member Posts: 655
    If you don't want to filter manually like "19.50|21.50|45.50" the only way is pass via code with something like:
    IF ABS(DecValue - ROUND(DecValue,1,'=')) = 0.50 THEN
  ...
    * Daniele Rebussi * | * Rebu NAV Diary *
  • hhhhhhhqat
    hhhhhhhqat Member Posts: 111
    HI ...


    DecValue is a variable defined for field.table ? ... or variable as decimal ? ..

    coz it's not giving me the right value ..
  • geordie
    geordie Member Posts: 655
    It's the table field, create a report/dataport to perform the operation you need and use that statement to process or skip the records.
    What error did you receive?
    * Daniele Rebussi * | * Rebu NAV Diary *
  • hhhhhhhqat
    hhhhhhhqat Member Posts: 111
    actually no error , but it's not filter .. its just export all records ..
  • hhhhhhhqat
    hhhhhhhqat Member Posts: 111
    Thanks geordie

    it's OK now ... i correct the code

    thanks for your help ..
  • geordie
    geordie Member Posts: 655
    Glad it worked, remember to mark the topic as solved.
    * Daniele Rebussi * | * Rebu NAV Diary *
  • hhhhhhhqat
    hhhhhhhqat Member Posts: 111
    Thanks for every one support .. issue solved

Categories