I have the field “Calendarweek” in my data (numerically formatted, YYYYWW, e.g. 202437). Now I would like to calculate for each entry how often the value “Qualification” is present in the field “Diploma” within the last 8 calendar weeks. This should work independently of the currently set filters. If the value is present at least once, the formula should return “Yes”, otherwise “No”. I have tried the following formula: