-
1. Re: Tableau is not performing a calculation correctly
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.
Best,
--Matt
-
2. Re: Tableau is not performing a calculation correctly
Hi Shap,
If you are specific about the decimal points, please change the Default properties of the Calculated filed to Custom Number--> Decimal--> .2 places.
-
3. Re: Tableau is not performing a calculation correctly
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.
Thanks
J
-
4. Re: Tableau is not performing a calculation correctly
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)
-
5. Re: Tableau is not performing a calculation correctly
Thanks soooooo Much! such a simple solution.
