see the attached
calculating totals in table calculations can be tricky
I changed your % calculation as shown
and it returns
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
It worked like a charm.!