Fix for this issue is now available in the latest update of InDesign 2020 – that is, InDesign 15.0.1
In the Creative Cloud Desktop application, click on the Updates section on the left. You should be able to see the Update available for InDesign. Please update your InDesign application to this version to try out the fix.
Let us know in the comments section if you face any problem with the updation process.
Adobe InDesign Team
An error occurred while saving the commentJordan Atkinson commented
Having the same issue here. Appears to work fine in Indesign 2019 but 2020 isn't pulling through sum values. Example of Excel doc and Indesign (2020) table attached.