Editing report / bordereaux - one case, three insurers
I am currently attempting to set up a report for one of our insurers, WR Berkley. Within the particular scheme, I have a case which has EL and PL cover with WR Berkley, legal expenses with a second insurer and CAR cover with a third insurer.
Having selected the insurer I wish to run the report for, WR Berkley, I have selected the fields I need. However as you will see from the screenshots attached, the legal expenses and CAR cover premiums are appearing on the report, whereas in fact they should be reading as zero.
How do I reference the only insurer I require? How do I create an "If" statement in my formulae?
If I am unclear, please let me know and I'll try to explain my problem in a different way.
Many thanks in advance.
Screenshots for WR Berkley Report.docx
Please sign in to leave a comment.
Comments
2 comments