Print Page - TAM Reports

Title: TAM Reports - sub-policies
Post by: Andrew Carrick on November 23, 2010, 11:27:38 AM

On BoB, you can select "first risk only". On the equivalent Policy Search you can only select "One risk per policy", and the one that gets picked can be the sub-policy with zero premium so it skews the figures. Anybody know a way around this? I want to be able to list policies and premiums for the main risk only.

TIA.

Title: Re: TAM Reports - sub-policies
Post by: Lance Bateman on November 23, 2010, 11:46:58 AM

I think using search/active policies with an extra criteria specifying you only want those ending with "-001" might work for you.

Title: Re: TAM Reports - sub-policies
Post by: Andrew Carrick on November 23, 2010, 11:53:53 AM

Thanks, that appears to have done the job - extra criteria RIGHT(Policy.pol_idx,3)="001" if anybody else wants it.

Applied Users Forums

General Topics => Helpline => Topic started by: Andrew Carrick on November 23, 2010, 11:27:38 AM