Hi,
I am pretty new to access in general so forgive me because I have seen this posted elsewhere but do not know how to apply it to my situation.
I am essentially trying to do a-b/b, however b can be null or zero.
round(abs(((im.metric_val-i.bid)/i.bid)*100),3) AS Abs_Pct_Diff
if i.bid is null or zero I'm okay with having it return 0.
I have seen several suggestions to try nz or IIF statements but I cannot write them properly given my query.
Any help is appreciated,
Thanks!