Dear Forum members, FIFO formula works for the first calculation. But not for the 2nd calculation. For the 2nd calculation it only works if we shift the 2nd calcualtion formula one coloumn right. I have attached excel for more details. Could you pls tell me what's wrong with the formula
Bookmarks