=formatnumber(Median(ToNumber(Right([Fiscal year];4)));"##")
The reason of Median function is not working as you are applying on the string datatype.
First you have to convert string to number and then apply median().
=Median(tonumber(Right([Fiscal year];4)))
One more observation MIN/MAX functions will not retrun always correct values with string datatype.Convert then also in number data type.
=Min(tonumber(Right([Fiscal year];4)))
Add comment