Hey J Shap,
In the SAS dataset, using your example are the numbers exactly 3 and 5? Tableau will pull in whatever the data is.
If this is causing you to report the wrong numbers you can use the ROUND () Function to "solve" this.
thanks guys for your reply. I am attaching a sample workbook.
you can see that the variables I am using are whole numbers.
I am using the percent's to create percentage buckets so just formatting the percent variable doesn't get me my desired result.
I just cannot figure out why the calculated variable is not performing the division correctly.
if you see anything please let me know.
Book4.twbx 54.3 KB
There are always annoying errors involving floating point numbers. This has nothing to do with Tableau, it's just the nature of computing systems.
It is also why you should always set a measure as a whole number if it is an integer, or a float if it contains numbers with decimals. The solution is to set both 'Total Spanish Language' and 'Units' as whole numbers:
Right click on measure -> Change Data Type -> Number (whole)
Thanks soooooo Much! such a simple solution.