Calculation is read too many times!
Andrew Nisbett
I have a calculation that shows me which week I will run out of material the issue is It calculates for every week shown. I need it to be read once and show how many weeks I have left e.g I we are in week 27 and I have 2.8 weeks of stock so the week 29 cell should be highlighted in yellow. But when I drop the calculation into “rows” I get it calculated more than once.