https://community.fabric.microsoft.com/t5/Report-Server/Error-when-using-Sum-function-in-paginated-report/m-p/3309009#M30320 <P>When ever I am trying to sum a column, instead of getting a number if get #error. The column is filled with currency values. There are some cells that are blank so that could be the issue.&nbsp;</P><P>Here are some things I have tried:&nbsp;</P><P><STRONG>=SUM(IIf(IsNothing(Fields!External_20_Review_Fee.Value),0,Fields!External_20_Review_Fee.Value))</STRONG></P><P><STRONG>=SUM(Fields!External_20_Review_Fee.Value)</STRONG></P><P><STRONG>=SUM(IIf(INT(Fields!External_20_Review_Fee.Value),0,INT(Fields!External_20_Review_Fee.Value))</STRONG></P> Thu, 29 Jun 2023 21:41:00 GMT hannahsamd 2023-06-29T21:41:00Z https://community.fabric.microsoft.com/t5/Report-Server/Error-when-using-Sum-function-in-paginated-report/m-p/3309009#M30320 <P>When ever I am trying to sum a column, instead of getting a number if get #error. The column is filled with currency values. There are some cells that are blank so that could be the issue.&nbsp;</P><P>Here are some things I have tried:&nbsp;</P><P><STRONG>=SUM(IIf(IsNothing(Fields!External_20_Review_Fee.Value),0,Fields!External_20_Review_Fee.Value))</STRONG></P><P><STRONG>=SUM(Fields!External_20_Review_Fee.Value)</STRONG></P><P><STRONG>=SUM(IIf(INT(Fields!External_20_Review_Fee.Value),0,INT(Fields!External_20_Review_Fee.Value))</STRONG></P> Thu, 29 Jun 2023 21:41:00 GMT https://community.fabric.microsoft.com/t5/Report-Server/Error-when-using-Sum-function-in-paginated-report/m-p/3309009#M30320 hannahsamd 2023-06-29T21:41:00Z