Filters on FlowField having Lookup type

Hi all, I’m experiencing a problem in filters (client NAV 2009): I created a FlowField having type Lookup on a table in order to see a decimal field taken from another table. I put this new field on a tabular type form. When I try to apply a filter on that field (for example a range 1…10 or any other formula like >1), the result is not correct (I see just one record, instead of the multiple records I should see).

It seems that the client is not able to manage filters on those type of field on a tabular form. Probably it is not able to calculate the value of the flowfield before applying the filter.

Does anyone had the same problem?

Thanks,
Marco

I found the problem. The CaclFormula of the field linked a field to another FlowField, so the calculation was unreliable!

Marco