Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Members,
There are two tables where one carry policy data & other Debtor information. Both table have couple of common fields which is the REF Number & risk date. The commissions due on policy data were computed against the premium at different PRD category. Once both tables are loaded, I need following out put to be made.
Check the Ref Number in both table & if the commissions in the Policy data are equal to the Debtor value in the Debtor file or Commissions in the policy data are greater than the Debtor vale, such records to be identified as Net Com & others as No records.
I have annexed qvd & two excels for your ref. Hope you may correct me if I have done anything wrong in the script in the process.
Thanks in advance
Neville
Excel attachments
Pivot table prepared is attached. Help me to create all I want at the front end