Hidden Calculation Field Showing 0

When Colin Came to chat with us the other day, we set up a hidden calculated field to show the Total Turnover on the PL tab of the Contractors+ scheme.

At this point the Total was working, but not correct as I had missed 1 field out of the calculation in the Rating file.

I was away for a week, when I returned, I discovered one of the guys here had renamed the TABS from things like PL to Public Liability(PL) while I was away.

(Not sure if this would have had an affect, so I have left them in their changed state?)

However, the total both on the PL tab and the Matrix now says 0.

I tried a number of things to try and fix this:

I renamed all the fields to recognisable systemID's as suggested during our chat.

I changed the Rating file to include one other field in the calculation as it had been missed out.

I saved the Rating file to a location on the server and uploaded it to my scheme from this location.

I set each field involved in the calculation to Coverage.

This then gave me a total Cover in the Matrix of the value I was hoping for in Total Turnover.

Unfortunately,  the total both on the PL tab and the Matrix still says 0.

Could you let me know what I might be missing?

Regards

Teresa Manguzi