Can somebody please assist me please? I need to do an If Else statement or something simialar for this:
Display the total of "AUTHORISED AMOUNT" for all claims of which the "INCIDENT DATE" fell within the date range of each Catastrophy start and end date (Excel Document 'Catastrophy Incidents'). If the "AUTHORISED AMOUNT" is R0, use the field "CLAIMED AMOUNT" as a value. For this view, you should only include claims where the CLAIM STATUS is not equal to 'R' or 'Z'.