I have a field 'Age' whenever it is less than 1 year it comes as '0' in the flat file but shows '#' sign in the reports. Age was defined as a NUMC data type, character length 3.
Problem is I wanted it to be shown as 0 and not #. Can we do something without changing the object as key figure as it acts as an attribute for an other characteristic.
Any idea would be helpful.