@Heather is correct, there is no evaluation context coming from projections[Projection Category] in the Total row. So you’d need to bring that context back using an iterator to calculate the correct result.
Below some resources to help you fix it. But you can also use the Search option in the upper right corner because there’s a lot of content on this subject available within the forum.