We can't summarize this field with Sum (power pivot)

[sovietchild]

Hello, I have a problem. One of my columns is showing as count and not as sum like I wanted. I get an error that says "We can't summarize this field with sum because it's not a supported calculation for Text data types."

Is there anyway around it? This is Power pivot table. The column that I have problem with called Expected Sales.

Thank you

[sandy666]

on Daily Hours Log use M3: =IFERROR(SUM([@HOURS]*[@RATE]),0)
then refresh PivotTable and change Expected Sales from count to sum

[sovietchild]

on Daily Hours Log use M3: =IFERROR(SUM([@HOURS]*[@RATE]),0)
then refresh PivotTable and change Expected Sales from count to sum

Thank you so much! I'm lost of words.

[sandy666]

You are welcome

Have a nice day

[dan_ornelas]

Hello, first time posting here. I am having this same issue but with a Power Pivot, Pivot table. Any insights on how to correct this? I'm inserting several pivot tables for a dashboard but, for some reason, only with this one column do I get this error. I've reviewed the data over and over to no avail. Thank you! Dan

[kaleyanne]

Thanks for the reply, by adding the if-error statement you removed the circumstances that didn't result in a number allowing the system to perform the calculation. So if you are running into the same issue. Add an if-error statement with a resulting value of 1 or 0 or whatever suits your data best and refresh & it should work. Hope that helps.