I use code that displays the moving 7 day average propane usage.

Unfortunately, whenever I get a tank fill up, the average gets messed up.

I use this code:

if(isNull(weekagopropane) || isNull(currentpropane), NULL, (weekagopropane-currentpropane)*10)

I tried the following but got an error on column 125 that I can't figure out:

if(isNull(weekagopropane) || isNull(currentpropane) || isNull(dayagopropane), NULL, (if((weekagopropane-currentpropane)<=1) , (dayagopropane-currentpropane)*10,(weekagopropane-currentpropane)*10)

Can someone please help me?

Thanks!