Hi!
I need to make a calculation between the "Cobertura" value of the events that are in the "Ocorrência" tab
(only "Ocorrência válida?" in "SIM") and the "Base" tab of those who have the "Situação Contrato" "ATIVO".
So that the "Referência" tab is the guide, and the columns "INICIO" as the start date delimiting the period, "FINAL" as the end date
period delimiter and "REFERÊNCIA" as the period identifier.
In short, I need to check if the cases in the "Ocorrência", "Dt. Evento" tab are contained in "Dt. Início Vigência" and "Dt. Fim Vigência" of their
respective "Contrato" on the "Base" tab and check the name of the equivalent month on the "Referência" tab (considering the "INICIO" and "FINAL" columns).
So that I can reach the goal that is to divide the "Cobertura" value of the "Base" tab with the "Ocorrência" tab.
I must preserve the possibility of using filters such as "Modelo Veículo", "Tipo Veículo".
File for illustration
