Removing "#division by zero" from dashboard

Box2105

I have a financial report in my dashboard that show the forecast, actuals, variance and variance % for each month (Jan to Dec). Mid-year months that done not have actuals yet show "#division by zero" in the %VAR column.

Is there a way to not show the "#division by zero" in the dashboard?

Mike TV

Add "IFERROR" function to the start of your existing formula and end it with a double quote ("") so that it will leave the cell blank instead of displaying an error.

Mike TV

Add "IFERROR" function to the start of your existing formula and end it with a double quote ("") so that it will leave the cell blank instead of displaying an error.