cancel
Showing results for 
Search instead for 
Did you mean: 

Context Issue

former_member917911
Discoverer
0 Kudos

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

Accepted Solutions (0)

Answers (0)