Calc Fields with a same name

Hello,

I have a problem with finding a number of fields with a same name.

More exactly:
On column has the data type Code, there are many names for example, Lorem, Lorem1, Lorem2, Lorem etc.I need to find the number of the same names in that column. for example how many Lorem names are in this column.

Maybe this is a amator question but i have just two weeks working on NAV.

Thank you.

You should use SETFILTER for this purpose. For example the following code will give you the number of customers, who have ‘home’ (irrespective of lower / upper case) in the name field

Customer.RESET;
Customer.SETFILTER(Name,’@HOME’);
MESSAGE(’%1’,Customer.COUNT);