Out of curiosity. What if I wanted to calculate the traffic light based on two dimensions?
For example: Department_DB and Department_Excel. This is used to check whether the entry for a department in Excel is the same as the Department_DB.
Since mismatches can occur here for example "DepA" in Excel is assigned to "DepB" in the DB for a certain calendar week, how can one set the traffic light so that both dimensions are checked for the week field and result in TRUE if both equal to true?
Department_Excel Department_DB Week DepA DepA 31 DepA DepB 32