Filter in decimal field

hhhhhhhqat

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 .

geordie

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
  ...

hhhhhhhqat

HI ...


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

coz it's not giving me the right value ..

geordie

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?

hhhhhhhqat

actually no error , but it's not filter .. its just export all records ..

hhhhhhhqat

Thanks geordie

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

thanks for your help ..

geordie

Glad it worked, remember to mark the topic as solved.

hhhhhhhqat

Thanks for every one support .. issue solved