Thank you for your reply. I think you are correct that it has something to do with the self weight.
Firstly I amended the model so that the self weight wasn't double counted.
I then ran it for the Combination Case 22 which has 1*LC1 Self weight + 1*LC2 Super imposed dead + 0.1*LC5 Live Load. (All the results are shown on the attached excel file)
These results show a similar discrepancy between the sum of the total nodal modal masses and the total modal mass.
Next I ran it for LC2 Super Imposed Dead load only. For this case the nodal modal masses DID add up to the total modal mass 🙂
Finally I ran it for LC1 Self weight only. Again, as for the combination case containing the self weight, the nodal modal masses did NOT add up to the total modal mass. (I double checked this last option by using the disregard density button in the modal analysis tab, with no load cases in load to mass conversion. The results (as they should be) were identical to using LC1 which is just selfweight.)
Why if you include the self weight in the modal analysis (which you almost always do) does the sum of all the nodal modal mass not equal the total modal mass?