Help With expression

I have this expression in a table:

=Sum(Fields!External_20_Review_Fee.Value)

It keeps haveing an error because there are blanks in the column.

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.

0 REPLIES 0

Helpful resources

Announcements

Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.