Skip to Content
0
May 16, 2022 at 08:13 PM

Context Issue

407 Views

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.

Thanks