Removing "#division by zero" from dashboard

Options

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?

Best Answer

  • Mike TV
    Mike TV ✭✭✭✭✭✭
    Answer ✓
    Options

    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.

Answers

  • Mike TV
    Mike TV ✭✭✭✭✭✭
    Answer ✓
    Options

    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.