Research shows that ambivalence in leaders and team members is a two-edged sword. It can boost performance, but also hurt your chances for promotion. Why?