I think that it needs to know what Max of year you are talking about. What I do is (temporarily) place a cell in portion of report that you want Max year for (e.g. all of report or section) and place Max formula in the cellβ¦then click on cell and go to Data/Define as Variable. Name it and tick the Define in Context box. THEN use that variable to compare with your year (and you can delete the cell also).