7 Replies Latest reply on May 3, 2018 10:06 AM by Simon Runc

# Difference between excel and tableau calculations

Hello -

Hoping someone else has had similar issues. I am running the exact same calculations in a tableau report as i was an excel sheet... but i'm getting slightly different numbers. I wanted to push it into tableau so i could make the report more automated, but i'm worried about the difference between my findings in the excel and tableau report.

Has anyone had similar issues with this kind of thing? Only guess i have is that i'm using ROUND functions, excel and tableau might have different places where they round to?

• ###### 1. Re: Difference between excel and tableau calculations

Hi Troy

Very difficult to provide a soulduiton without seeing the twbx work book and the calculations you are trying to recreate - it is true that tableau and excel could have different levels of precision - BTW Excel is cell based and Tableau is database oriented and while the formulas look similar they are not the same

Jim

If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

• ###### 2. Re: Difference between excel and tableau calculations

Hello Troy,

It will depend on the data and how you are placing the row/column shelf. Can you provide sample data or .twbx file to better understand the issue?

S

• ###### 3. Re: Difference between excel and tableau calculations

Excel:

Tableau:

S

2 of 2 people found this helpful
• ###### 4. Re: Difference between excel and tableau calculations

hi Sudheer,

So my Excel gives the same as Tableau!

Your Excel is the wrong one as it has 3 decimal places, and you've asked for 2! I suspect you don't have "auto-calculations" turned on in Excel. Despite any quibbles I may have with Excel, I don't doubt that it can do a round function correctly (some one would have spotted it in the last 28 years! ...yes Excel is 28 years old this year!)

1 of 1 people found this helpful
• ###### 5. Re: Difference between excel and tableau calculations

Hello Simon,

I am also getting the same value in Excel and Tableau. The number before rounding 1424.147 after rounding 1424.15. I've attached it wrongly.

S

• ###### 6. Re: Difference between excel and tableau calculations

thanks everyone for the replies. i more or less needed just a reason why they could be off a bit. i know that rounding and then doing calculations will tinker with the numbers slightly. Especially if i continue to create calculations off those calculations. Thank you again!

• ###### 7. Re: Difference between excel and tableau calculations

Yes...rounding a number and then performing a calculation on it, (might) yield different results to performing a calculation and then rounding the answer.