Calculated fields from Google Sheets

[Jcwilde]

I have my report linked to a google sheet and I created a new field with a simple formula to add several columns of related data together. However when I go to display it on the table most of the new fields values come back as 0 and I noticed that if I remove the calculation (basically just assign that field’s value to that one column) it works fine. 

Is there a way to do this. In Excel it is a pretty basic pivot table.