I came across this post when I was taking a look at older unanswered questions. This is a good question, and an aspect of calculated fields + data blending that trips a lot of people up. I've attached a version of your workbook that has a corrected calculated field. This article from our knowledge base helps explain what I did: Error "All fields must be aggregate or constant..."
Hope this helps!