New here so a detailed answer would be helpful. I have a report that has the following colums.
EmployeeID | Language | Language Date | English Currrent |
Bob | German | 23/2/2021 | Yes
Mary | French | 12/12/2017 | No
Jim | SPanish | 12/2/2021 | Yes
The language colum is filtered to only display German, French, Spanish.
The English Current is a variable calculated from
= IF ( [Language] = "English" AND [Language Date] < CurrentDate() ) THEN "Yes" ELSE "No"
Then I want the English current colum displayed against each person, even though that row does not relate to english.
I hope this makes sense.