change the lod to this - in words it says for each year give me the max closing period
and it will return for 17 and 18
you can of course filter the fy
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.