I have Power Pivot tables with calculated fields using the SUM formula.
If one of the columns being summed is blank, the refresh results in an error saying "The function SUM takes an argument that evaluates to numbers or dates and cannot work with values of type String."
I need to find a way to handle this situation, because I have many data tables and it is very possible that not all of them will have data in them all of the time.
A normal pivot table would just return a SUM of 0 rather than error out. It also does not work to use IFERROR ... because it isn't that the calculated field returns an error, it's that the actual refresh will not complete and an error message pops up.
If one of the columns being summed is blank, the refresh results in an error saying "The function SUM takes an argument that evaluates to numbers or dates and cannot work with values of type String."
I need to find a way to handle this situation, because I have many data tables and it is very possible that not all of them will have data in them all of the time.
A normal pivot table would just return a SUM of 0 rather than error out. It also does not work to use IFERROR ... because it isn't that the calculated field returns an error, it's that the actual refresh will not complete and an error message pops up.