When you say TBM I take you mean what we used to call "Cost Transparency", now IBM Apptio Costing.
One of the reasons might be that when you import the CSV file, the column holding that piece of data is marked as Label (A) in the picture:
If this is not the case, try to see which of the values in the column is causing the #VALUE error. One way to do that is right-clicking on the column header and asking the engine to "Show Values"
CT will display something like this:
I take it that, in your case, CT displays a #VALUE error in the total. Try to sort the data either way and see if you find something that is not numeric. The value you give should work