What happens if you alter the format to 1 decimal place instead of standard? Assuming 1 d.p. is what you want of course.
I do want it here, but in other places the client wants 0 d.p. That's why I tried to format it in Excel so it would be correct in Tableau.
Is there any logic behind where the client wants 0 d.p. versus 1 d.p.? If so it may be possible to resolve this in a formula using ROUND()
Yes, there is logic behind when to use one or the other. Zero d.p. for counts and dollars, 1 d.p. for rates. I will look at using rounding, but still haven't answered the question why the formatting is funky in this one place on the viz.
I created a calculated field with this formula
IF [Data Type] = 'Count'
OR [Data Type] = 'Dollars'
THEN ROUND([State Data],0)
Does this look right?
If I use this calculated field, what do I set as the default number formatting for the field?
It looks about right, you may need to put the aggregation into the formula - i.e. SUM([State Data]) - to make it work but no doubt you've tried it so have a good idea whether it's working or not.
I think you just set the number formatting to the default as the formatting happens within the calculated field.