Alert if any host is above the threshold

Instead of having query B as a Classic Condition, try changing it to Reduce, then create query C with your expression (>100). Your query is nearly the same as mine. See here and please report back here if it fixes your issue.