I have a field that has been loaded using the YearName() and has a value in it of 2020-2021. I'm attempting to use that in a formula for a KPI in the visualization and I get an error I can't seem to get around. If I hard set it to the value with '2020-2021' for the MaxString value the formula works.
My only thought is the "-" in the value the YearName() creates (2020-2021) is creating a problem since if I hard set it with quotes around it the formula works.
Any thoughts or ideas would be greatly appreciated.