Thank you. I will give this a try!

Yes, unfortunately, sometime ago, smallint was selected as percent for system wide default. We don't want to change the system wide default at this time, as to not interfere with reports that have already been created. I tried to set the system default for the column year to number, but it doesn't translate into year in…

Screenshot as requested: It is set as the key for the year level and has data type of smallint:

Okay, fair enough. I did misunderstand what you were saying. But I still need to be able to get year to not be pulled through as a percentage. Do you know how I would go about that?

Year is pulling through as plain text, when it is defined as a smallint. Do you have any insight in how I would get it to pull through as a number? Year pulls through as a number outside of the hierarchy. Also, thanks for the quick response!