Gareth Horton
July 12th, 2002, 01:32 PM
Just to expand on John's solution -
Try the .In. / .NotIn. operators, they allow the specification of a list, i.e.
CoName .NotIn.(CompanyA,CompanyB,CompanyC) etc
It may be easier, espeically if you can export the names you want / don't want in a comma seperated format.
Gareth
John Fitzgerald wrote:
> Yes, you would be able to use a filter to select just those company names. The filter formula would look like:
>
> CoName="Company A" .Or. CoName="Company B" .Or. CoName="Company C" ...
>
> A decent amount of typing with 70 company names, but it would do the job!
>
>
> Pims wrote:
> > Would anyone be able to tell me if the filter capability of Monarch will allow the following:
> >
> > I have a report that lists transactions involving various companies (over 200). I would like the final report to reflect certain companies (about 70), eliminating those entries that do not match. Is this possible, to create a filter list of companies?
> >
> > Thank you for your response.
>
Try the .In. / .NotIn. operators, they allow the specification of a list, i.e.
CoName .NotIn.(CompanyA,CompanyB,CompanyC) etc
It may be easier, espeically if you can export the names you want / don't want in a comma seperated format.
Gareth
John Fitzgerald wrote:
> Yes, you would be able to use a filter to select just those company names. The filter formula would look like:
>
> CoName="Company A" .Or. CoName="Company B" .Or. CoName="Company C" ...
>
> A decent amount of typing with 70 company names, but it would do the job!
>
>
> Pims wrote:
> > Would anyone be able to tell me if the filter capability of Monarch will allow the following:
> >
> > I have a report that lists transactions involving various companies (over 200). I would like the final report to reflect certain companies (about 70), eliminating those entries that do not match. Is this possible, to create a filter list of companies?
> >
> > Thank you for your response.
>