Hello everyone,
I need your help with a formula.
- Column 3 displays the stock quantity per item and location.
- Column 4 shows the last average price by location.
- Column 5 shows the last average price by item.
I need to calculate a column for the inventory value based on Column 3 and 5. The problem is that the values in Column 5 do not repeat for all rows.
In Column 6 and 7, I attempted to create the formula. In row 3, you can see that it outputs the wrong value, as it calculates 109 * 23.87 instead of 109 * 24.08.
I hope you can assist me with this.
Best regards,
Citris