https://community.fabric.microsoft.com/t5/Report-Server/Help-With-expression/m-p/3374805#M30816 <P>I have this expression in a table:</P><P>=Sum(Fields!External_20_Review_Fee.Value)</P><P>It keeps haveing an error because there are blanks in the column.&nbsp;</P><P>HOw do I ignore the blanks and add up the numbers. The blanks cannot be turned into zeros because of the requirement of the report.</P> Thu, 10 Aug 2023 17:51:12 GMT hannahsamd 2023-08-10T17:51:12Z https://community.fabric.microsoft.com/t5/Report-Server/Help-With-expression/m-p/3374805#M30816 <P>I have this expression in a table:</P><P>=Sum(Fields!External_20_Review_Fee.Value)</P><P>It keeps haveing an error because there are blanks in the column.&nbsp;</P><P>HOw do I ignore the blanks and add up the numbers. The blanks cannot be turned into zeros because of the requirement of the report.</P> Thu, 10 Aug 2023 17:51:12 GMT https://community.fabric.microsoft.com/t5/Report-Server/Help-With-expression/m-p/3374805#M30816 hannahsamd 2023-08-10T17:51:12Z