Hi, thank you for the replies.
To be clearer, when creating a dashboard, and while a visualization is selected, and while looking at the fields, you can click on the ellipsis (three dots next to the field name) and from there select format. If Cognos is recognizing the field as a number, you will have the option to set format to number, percent, etc. When Cognos sees this is a string, the only options are Text and Auto.
My issue is that Framework is seeing this a string field because of the letters in the Client Id.
In the database layer, I do have a separate count in my dimensional model, I do have this set as a measure, with a Regular Aggregate as a count distinct.
This still comes up as a "text" field in the dashboard.