I did not have the problem when I loaded a sample
I brought in the first code as a text on the excel sheet and the second as general
Tableau brought in each a s a number - I converted the first to a string by right clicking the data type in the dimension pane
I would suggest trying to convert what you loaded and seeing what the result would be
Thanks for helping out - much appreciated. Here is a screenshot of my data.
You can see that "Corrected Mtl#" is a string in the view above and there are no decimal values visible. If I change the data type from string to number (decimal) I get the following:
Now you can see the decimal values but any materials with text in them show up as null values - not a solution. I'm sure I'm missing something simple here.