#error when trying to sum a calculated field in ssrs.

I was getting the #error when trying to sum data of a specific column field in SSRS.
I fixed it. Mostly this occurs due to conversion of one data type to other, when it fails to convert it throws #error .

To fix it. Please follow the below steps.

Step 1 –
Go to the cell where summation formula is added. Right click on it, then click Expression…

Step 2 –
You can see the expression like the below screen. Change it by following step 3.

Step 3 –
Here we are changing the expression by adding CDEC, it converts the text to decimal.

This will fix the issue. Please follow the below screen.

Hope this helped you. Happy programming.:)