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?
TotYoYVar%: ([2016FcstTotal]-[2015Total])/[2015Total]
How can I prevent Access from returning a result of #Error when [2015Total] is 0?