TAM Reports - sub-policies

[Andrew Carrick]

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.

[Lance Bateman]

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

[Andrew Carrick]

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