Display year based on range of numbers

Options
davargas
davargas Member, ALL USERS Posts: 5 New Contributor

Hello, I have a module that contains a bunch of servers, and for each server there is an asset tag. The asset tags are in sequential order. I was wondering if it was possible to display the year for each server based on a range of the asset tags. For example, for a given sever, I would like it to display FY17 if its asset tag number is in between 40,000 and 50,000. The ranges should change for each year. My model accounts for FY07-FY23.