Year Over Year Variance #Error

[ALewis06]

I am trying to do a very simple calculation in a query to determine year over year variance displayed as a percentage:

TotYoYVar%: ([2016FcstTotal]-[2015Total])/[2015Total]

How can I prevent Access from returning a result of #Error when [2015Total] is 0?

 

[CJ_London]

use an iif statement

TotYoYVar%: iif([2015Total]=0,0,([2016FcstTotal]-[2015Total])/[2015Total])

note, generally not a good idea to use non alphanumeric characters in field names

 

[ALewis06]

Worked perfectly! Thanks

 

[jdraw]

ALewis06,

Just a little info on the why of the issue and CJ's solution.
You really can not divide by 0 (get error attempt to divide by 0).

So as CJ said, check the divisor (/[2015Total]),
if it is 0, set the expression to 0, otherwise do the calculation.

Good luck.