if [Final Inventory]<=0 then 0 elseif [Row+1:Value]<0 and abs([Row+1:Value])>= [Final Inventory] then [Final Inventory]/abs([Row+1:Value])*7 elseif [Row+2:Value]<0 and abs([Row+1:Value]+[Row+2:Value])>= [Final Inventory] then ([Final Inventory]- abs([Row+1:Value]))/abs([Row+2:Value])*7 elseif [Row+3:Value]<0 and abs([Row+1:Value]+[Row+2:Value]+[Row+3:Value])>= [Final Inventory] then ([Final Inventory]- abs([Row+1:Value]+[Row+2:Value]))/abs([Row+3:Value])*7 elseif [Row+4:Value]<0 and abs([Row+1:Value]+[Row+2:Value]+[Row+3:Value]+[Row+4:Value])>= [Final Inventory] then ([Final Inventory]- abs([Row+1:Value]+[Row+2:Value]+[Row+3:Value]))/abs([Row+4:Value])*7 elseif [Row+5:Value]<0 and abs([Row+1:Value]+[Row+2:Value]+[Row+3:Value]+[Row+4:Value]+[Row+5:Value])>= [Final Inventory] then ([Final Inventory]- abs([Row+1:Value]+[Row+2:Value]+[Row+3:Value]+[Row+4:Value]))/abs([Row+5:Value])*7 elseif [Row+6:Value]<0 and abs([Row+1:Value]+[Row+2:Value]+[Row+3:Value]+[Row+4:Value]+[Row+5:Value]+[Row+6:Value])>= [Final Inventory] then ([Final Inventory]- abs([Row+1:Value]+[Row+2:Value]+[Row+3:Value]+[Row+4:Value]+[Row+5:Value]))/abs([Row+6:Value])*7 elseif [Row+7:Value]<0 and abs([Row+1:Value]+[Row+2:Value]+[Row+3:Value]+[Row+4:Value]+[Row+5:Value]+[Row+6:Value]+[Row+7:Value])>= [Final Inventory] then ([Final Inventory]- abs([Row+1:Value]+[Row+2:Value]+[Row+3:Value]+[Row+4:Value]+[Row+5:Value]+[Row+6:Value]))/abs([Row+7:Value])*7 elseif [Row+8:Value]<0 and abs([Row+1:Value]+[Row+2:Value]+[Row+3:Value]+[Row+4:Value]+[Row+5:Value]+[Row+6:Value]+[Row+7:Value]+[Row+8:Value])>= [Final Inventory] then ([Final Inventory]- abs([Row+1:Value]+[Row+2:Value]+[Row+3:Value]+[Row+4:Value]+[Row+5:Value]+[Row+6:Value]+[Row+7:Value]))/abs([Row+8:Value])*7 elseif [Row+9:Value]<0 and abs([Row+1:Value]+[Row+2:Value]+[Row+3:Value]+[Row+4:Value]+[Row+5:Value]+[Row+6:Value]+[Row+7:Value]+[Row+8:Value]+[Row+9:Value])>= [Final Inventory] then ([Final Inventory]- abs([Row+1:Value]+[Row+2:Value]+[Row+3:Value]+[Row+4:Value]+[Row+5:Value]+[Row+6:Value]+[Row+7:Value]+[Row+8:Value]))/abs([Row+9:Value])*7 elseif [Row+10:Value]<0 and abs([Row+1:Value]+[Row+2:Value]+[Row+3:Value]+[Row+4:Value]+[Row+5:Value]+[Row+6:Value]+[Row+7:Value]+[Row+8:Value]+[Row+9:Value]+[Row+10:Value])>= [Final Inventory] then ([Final Inventory]- abs([Row+1:Value]+[Row+2:Value]+[Row+3:Value]+[Row+4:Value]+[Row+5:Value]+[Row+6:Value]+[Row+7:Value]+[Row+8:Value]+[Row+9:Value]))/abs([Row+10:Value])*7 elseif [Row+11:Value]<0 and abs([Row+1:Value]+[Row+2:Value]+[Row+3:Value]+[Row+4:Value]+[Row+5:Value]+[Row+6:Value]+[Row+7:Value]+[Row+8:Value]+[Row+9:Value]+[Row+10:Value]+[Row+11:Value])>= [Final Inventory] then ([Final Inventory]- abs([Row+1:Value]+[Row+2:Value]+[Row+3:Value]+[Row+4:Value]+[Row+5:Value]+[Row+6:Value]+[Row+7:Value]+[Row+8:Value]+[Row+9:Value]+[Row+10:Value]))/abs([Row+11:Value])*7 elseif [Row+12:Value]<0 and abs([Row+1:Value]+[Row+2:Value]+[Row+3:Value]+[Row+4:Value]+[Row+5:Value]+[Row+6:Value]+[Row+7:Value]+[Row+8:Value]+[Row+9:Value]+[Row+10:Value]+[Row+11:Value]+[Row+12:Value])>= [Final Inventory] then ([Final Inventory]- abs([Row+1:Value]+[Row+2:Value]+[Row+3:Value]+[Row+4:Value]+[Row+5:Value]+[Row+6:Value]+[Row+7:Value]+[Row+8:Value]+[Row+9:Value]+[Row+10:Value]+[Row+11:Value]))/abs([Row+12:Value])*7 elseif [Row+13:Value]<0 and abs([Row+1:Value]+[Row+2:Value]+[Row+3:Value]+[Row+4:Value]+[Row+5:Value]+[Row+6:Value]+[Row+7:Value]+[Row+8:Value]+[Row+9:Value]+[Row+10:Value]+[Row+11:Value]+[Row+12:Value]+[Row+13:Value])>= [Final Inventory] then ([Final Inventory]- abs([Row+1:Value]+[Row+2:Value]+[Row+3:Value]+[Row+4:Value]+[Row+5:Value]+[Row+6:Value]+[Row+7:Value]+[Row+8:Value]+[Row+9:Value]+[Row+10:Value]+[Row+11:Value]+[Row+12:Value]))/abs([Row+13:Value])*7 elseif [Row+14:Value]<0 and abs([Row+1:Value]+[Row+2:Value]+[Row+3:Value]+[Row+4:Value]+[Row+5:Value]+[Row+6:Value]+[Row+7:Value]+[Row+8:Value]+[Row+9:Value]+[Row+10:Value]+[Row+11:Value]+[Row+12:Value]+[Row+13:Value]+[Row+14:Value])>= [Final Inventory] then ([Final Inventory]- abs([Row+1:Value]+[Row+2:Value]+[Row+3:Value]+[Row+4:Value]+[Row+5:Value]+[Row+6:Value]+[Row+7:Value]+[Row+8:Value]+[Row+9:Value]+[Row+10:Value]+[Row+11:Value]+[Row+12:Value]+[Row+13:Value]))/abs([Row+14:Value])*7 elseif [Row+15:Value]<0 and abs([Row+1:Value]+[Row+2:Value]+[Row+3:Value]+[Row+4:Value]+[Row+5:Value]+[Row+6:Value]+[Row+7:Value]+[Row+8:Value]+[Row+9:Value]+[Row+10:Value]+[Row+11:Value]+[Row+12:Value]+[Row+13:Value]+[Row+14:Value]+[Row+15:Value])>= [Final Inventory] then ([Final Inventory]- abs([Row+1:Value]+[Row+2:Value]+[Row+3:Value]+[Row+4:Value]+[Row+5:Value]+[Row+6:Value]+[Row+7:Value]+[Row+8:Value]+[Row+9:Value]+[Row+10:Value]+[Row+11:Value]+[Row+12:Value]+[Row+13:Value]+[Row+14:Value]))/abs([Row+15:Value])*7 elseif [Row+16:Value]<0 and abs([Row+1:Value]+[Row+2:Value]+[Row+3:Value]+[Row+4:Value]+[Row+5:Value]+[Row+6:Value]+[Row+7:Value]+[Row+8:Value]+[Row+9:Value]+[Row+10:Value]+[Row+11:Value]+[Row+12:Value]+[Row+13:Value]+[Row+14:Value]+[Row+15:Value]+[Row+16:Value])>= [Final Inventory] then ([Final Inventory]- abs([Row+1:Value]+[Row+2:Value]+[Row+3:Value]+[Row+4:Value]+[Row+5:Value]+[Row+6:Value]+[Row+7:Value]+[Row+8:Value]+[Row+9:Value]+[Row+10:Value]+[Row+11:Value]+[Row+12:Value]+[Row+13:Value]+[Row+14:Value]+[Row+15:Value]))/abs([Row+16:Value])*7 elseif [Row+17:Value]<0 and abs([Row+1:Value]+[Row+2:Value]+[Row+3:Value]+[Row+4:Value]+[Row+5:Value]+[Row+6:Value]+[Row+7:Value]+[Row+8:Value]+[Row+9:Value]+[Row+10:Value]+[Row+11:Value]+[Row+12:Value]+[Row+13:Value]+[Row+14:Value]+[Row+15:Value]+[Row+16:Value]+[Row+17:Value])>= [Final Inventory] then ([Final Inventory]- abs([Row+1:Value]+[Row+2:Value]+[Row+3:Value]+[Row+4:Value]+[Row+5:Value]+[Row+6:Value]+[Row+7:Value]+[Row+8:Value]+[Row+9:Value]+[Row+10:Value]+[Row+11:Value]+[Row+12:Value]+[Row+13:Value]+[Row+14:Value]+[Row+15:Value]+[Row+16:Value]))/abs([Row+17:Value])*7 elseif [Row+18:Value]<0 and abs([Row+1:Value]+[Row+2:Value]+[Row+3:Value]+[Row+4:Value]+[Row+5:Value]+[Row+6:Value]+[Row+7:Value]+[Row+8:Value]+[Row+9:Value]+[Row+10:Value]+[Row+11:Value]+[Row+12:Value]+[Row+13:Value]+[Row+14:Value]+[Row+15:Value]+[Row+16:Value]+[Row+17:Value]+[Row+18:Value])>= [Final Inventory] then ([Final Inventory]- abs([Row+1:Value]+[Row+2:Value]+[Row+3:Value]+[Row+4:Value]+[Row+5:Value]+[Row+6:Value]+[Row+7:Value]+[Row+8:Value]+[Row+9:Value]+[Row+10:Value]+[Row+11:Value]+[Row+12:Value]+[Row+13:Value]+[Row+14:Value]+[Row+15:Value]+[Row+16:Value]+[Row+17:Value]))/abs([Row+18:Value])*7 elseif [Row+19:Value]<0 and abs([Row+1:Value]+[Row+2:Value]+[Row+3:Value]+[Row+4:Value]+[Row+5:Value]+[Row+6:Value]+[Row+7:Value]+[Row+8:Value]+[Row+9:Value]+[Row+10:Value]+[Row+11:Value]+[Row+12:Value]+[Row+13:Value]+[Row+14:Value]+[Row+15:Value]+[Row+16:Value]+[Row+17:Value]+[Row+18:Value]+[Row+19:Value])>= [Final Inventory] then ([Final Inventory]- abs([Row+1:Value]+[Row+2:Value]+[Row+3:Value]+[Row+4:Value]+[Row+5:Value]+[Row+6:Value]+[Row+7:Value]+[Row+8:Value]+[Row+9:Value]+[Row+10:Value]+[Row+11:Value]+[Row+12:Value]+[Row+13:Value]+[Row+14:Value]+[Row+15:Value]+[Row+16:Value]+[Row+17:Value]+[Row+18:Value]))/abs([Row+19:Value])*7 elseif [Row+20:Value]<0 and abs([Row+1:Value]+[Row+2:Value]+[Row+3:Value]+[Row+4:Value]+[Row+5:Value]+[Row+6:Value]+[Row+7:Value]+[Row+8:Value]+[Row+9:Value]+[Row+10:Value]+[Row+11:Value]+[Row+12:Value]+[Row+13:Value]+[Row+14:Value]+[Row+15:Value]+[Row+16:Value]+[Row+17:Value]+[Row+18:Value]+[Row+19:Value]+[Row+20:Value])>= [Final Inventory] then ([Final Inventory]- abs([Row+1:Value]+[Row+2:Value]+[Row+3:Value]+[Row+4:Value]+[Row+5:Value]+[Row+6:Value]+[Row+7:Value]+[Row+8:Value]+[Row+9:Value]+[Row+10:Value]+[Row+11:Value]+[Row+12:Value]+[Row+13:Value]+[Row+14:Value]+[Row+15:Value]+[Row+16:Value]+[Row+17:Value]+[Row+18:Value]+[Row+19:Value]))/abs([Row+20:Value])*7 elseif [Row+21:Value]<0 and abs([Row+1:Value]+[Row+2:Value]+[Row+3:Value]+[Row+4:Value]+[Row+5:Value]+[Row+6:Value]+[Row+7:Value]+[Row+8:Value]+[Row+9:Value]+[Row+10:Value]+[Row+11:Value]+[Row+12:Value]+[Row+13:Value]+[Row+14:Value]+[Row+15:Value]+[Row+16:Value]+[Row+17:Value]+[Row+18:Value]+[Row+19:Value]+[Row+20:Value]+[Row+21:Value])>= [Final Inventory] then ([Final Inventory]- abs([Row+1:Value]+[Row+2:Value]+[Row+3:Value]+[Row+4:Value]+[Row+5:Value]+[Row+6:Value]+[Row+7:Value]+[Row+8:Value]+[Row+9:Value]+[Row+10:Value]+[Row+11:Value]+[Row+12:Value]+[Row+13:Value]+[Row+14:Value]+[Row+15:Value]+[Row+16:Value]+[Row+17:Value]+[Row+18:Value]+[Row+19:Value]+[Row+20:Value]))/abs([Row+21:Value])*7 elseif [Row+22:Value]<0 and abs([Row+1:Value]+[Row+2:Value]+[Row+3:Value]+[Row+4:Value]+[Row+5:Value]+[Row+6:Value]+[Row+7:Value]+[Row+8:Value]+[Row+9:Value]+[Row+10:Value]+[Row+11:Value]+[Row+12:Value]+[Row+13:Value]+[Row+14:Value]+[Row+15:Value]+[Row+16:Value]+[Row+17:Value]+[Row+18:Value]+[Row+19:Value]+[Row+20:Value]+[Row+21:Value]+[Row+22:Value])>= [Final Inventory] then ([Final Inventory]- abs([Row+1:Value]+[Row+2:Value]+[Row+3:Value]+[Row+4:Value]+[Row+5:Value]+[Row+6:Value]+[Row+7:Value]+[Row+8:Value]+[Row+9:Value]+[Row+10:Value]+[Row+11:Value]+[Row+12:Value]+[Row+13:Value]+[Row+14:Value]+[Row+15:Value]+[Row+16:Value]+[Row+17:Value]+[Row+18:Value]+[Row+19:Value]+[Row+20:Value]+[Row+21:Value]))/abs([Row+22:Value])*7 elseif [Row+23:Value]<0 and abs([Row+1:Value]+[Row+2:Value]+[Row+3:Value]+[Row+4:Value]+[Row+5:Value]+[Row+6:Value]+[Row+7:Value]+[Row+8:Value]+[Row+9:Value]+[Row+10:Value]+[Row+11:Value]+[Row+12:Value]+[Row+13:Value]+[Row+14:Value]+[Row+15:Value]+[Row+16:Value]+[Row+17:Value]+[Row+18:Value]+[Row+19:Value]+[Row+20:Value]+[Row+21:Value]+[Row+22:Value]+[Row+23:Value])>= [Final Inventory] then ([Final Inventory]- abs([Row+1:Value]+[Row+2:Value]+[Row+3:Value]+[Row+4:Value]+[Row+5:Value]+[Row+6:Value]+[Row+7:Value]+[Row+8:Value]+[Row+9:Value]+[Row+10:Value]+[Row+11:Value]+[Row+12:Value]+[Row+13:Value]+[Row+14:Value]+[Row+15:Value]+[Row+16:Value]+[Row+17:Value]+[Row+18:Value]+[Row+19:Value]+[Row+20:Value]+[Row+21:Value]+[Row+22:Value]))/abs([Row+23:Value])*7 elseif [Row+24:Value]<0 and abs([Row+1:Value]+[Row+2:Value]+[Row+3:Value]+[Row+4:Value]+[Row+5:Value]+[Row+6:Value]+[Row+7:Value]+[Row+8:Value]+[Row+9:Value]+[Row+10:Value]+[Row+11:Value]+[Row+12:Value]+[Row+13:Value]+[Row+14:Value]+[Row+15:Value]+[Row+16:Value]+[Row+17:Value]+[Row+18:Value]+[Row+19:Value]+[Row+20:Value]+[Row+21:Value]+[Row+22:Value]+[Row+23:Value]+[Row+24:Value])>= [Final Inventory] then ([Final Inventory]- abs([Row+1:Value]+[Row+2:Value]+[Row+3:Value]+[Row+4:Value]+[Row+5:Value]+[Row+6:Value]+[Row+7:Value]+[Row+8:Value]+[Row+9:Value]+[Row+10:Value]+[Row+11:Value]+[Row+12:Value]+[Row+13:Value]+[Row+14:Value]+[Row+15:Value]+[Row+16:Value]+[Row+17:Value]+[Row+18:Value]+[Row+19:Value]+[Row+20:Value]+[Row+21:Value]+[Row+22:Value]+[Row+23:Value]))/abs([Row+24:Value])*7 elseif [Row+25:Value]<0 and abs([Row+1:Value]+[Row+2:Value]+[Row+3:Value]+[Row+4:Value]+[Row+5:Value]+[Row+6:Value]+[Row+7:Value]+[Row+8:Value]+[Row+9:Value]+[Row+10:Value]+[Row+11:Value]+[Row+12:Value]+[Row+13:Value]+[Row+14:Value]+[Row+15:Value]+[Row+16:Value]+[Row+17:Value]+[Row+18:Value]+[Row+19:Value]+[Row+20:Value]+[Row+21:Value]+[Row+22:Value]+[Row+23:Value]+[Row+24:Value]+[Row+25:Value])>= [Final Inventory] then ([Final Inventory]- abs([Row+1:Value]+[Row+2:Value]+[Row+3:Value]+[Row+4:Value]+[Row+5:Value]+[Row+6:Value]+[Row+7:Value]+[Row+8:Value]+[Row+9:Value]+[Row+10:Value]+[Row+11:Value]+[Row+12:Value]+[Row+13:Value]+[Row+14:Value]+[Row+15:Value]+[Row+16:Value]+[Row+17:Value]+[Row+18:Value]+[Row+19:Value]+[Row+20:Value]+[Row+21:Value]+[Row+22:Value]+[Row+23:Value]+[Row+24:Value]))/abs([Row+25:Value])*7 else 0 endif