#Error

  • Thread starter mattc66 via AccessMonster.com
  • Start date
M

mattc66 via AccessMonster.com

I am getting a #Error when the result is a 0. I add the below IIF ISERROR and
still the EError shows up. How do I get rid of this error?
IIf(IsError([SumOfSLS_2008]-[SumOfSLS_2007])/[SumOfSLS_2007],0,[SumOfSLS_2008]
-[SumOfSLS_2007])/[SumOfSLS_2007]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS Project. Real progress of the project, % complete 1
iserror problem 10
Countdown macro - display settings 2
React JS Outlook Add-in - VS Code + WebPack - Unable to call external Web Service - CORS Issue 0
Outlook Add-in - Javascript based using React JS - VS Code + WebPack - Unable to call external Web Service 0
Grey background behind text document 1
Can't send emails on new PC 1
Expression Builder query with zero amounts 5

Top