OK. I have a workaround. You might not like it.
Remove the condition as it is.
Apply it to the text above the table only.
Now apply it to all rows in the table except the last one.
Now apply the condition to the last row.
Done in that order, it works.
Help others by clicking Correct Answer if the question is answered. Found the answer elsewhere? Share it here. "Upvote" is for useful posts.