Hi Juraj Thank you for the feedback. Here follows the instruction(im not sure at which measure i should add the script)? "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'."
Hi, the requirement is not clear to me. - There's no "AUTHORIZED AMOUNT"='R0', in fact, there are only numeric values, but those values which contain decimal separator are not interpreted correctly (they appear as text, not as number, so you need to correct this in script with Num#() function. EDIT: Done in script.) - The requirement says 'If the "AUTHORISED AMOUNT" is R0, use the field "CLAIMED AMOUNT" as a value.' I ask: what should I do in all other cases?' - You mention an excel "Catastrophy Incidents', but it is not loaded. (EDIT: I loaded the file from attached source) - Most importantly: the data model is not correct. You associated the ClaimsMaster and ClaimsListing with "CLAIM NUMBER" field, but this is not unique identifier for different policies. I think - with my very limited knowledge of the requirement - that you should use a compound key Policy*ClaimNumber or something similar (EDIT: see attached app and check if this seems correct). You can try uploading sample/mock data, if you want, maybe we'll be able to move forward with that.
EDIT: Thanks for reminidng me about the link to data. Check the attached app, most of points still stand though.