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. 

[Jcwilde]

Update: I noticed that I am able to add other columns using sum(column name)+sum(column name) however the data is just wrong. 

For example. Adding columns: Neon Red 1 + Neon Red 2 results in mostly 0’s however both columns have only positive numbers or blank data and if I remove the additional column both show more data in the table than when I try to add them together. 

[Jcwilde · Accepted solution]

Figured it out. It won’t add data with Null values. Added IfNull and it all works fine.