5 Replies Latest reply on Nov 22, 2012 2:15 AM by Guillaume Petit

    Wrong values exported when sending to cross-tab

    Guillaume Petit

      For various reasons, I ended up using a calculation like the one described by Joe in the following thread: http://community.tableau.com/thread/114860.

       

      While the calculation works great on screen, when sending the data to a cross-tab, the wrong values are sent to Excel. E.g. while the "grand total" shows as 38 on the screen, send it to Excel and you end up with 42.66. As if the whole calculation to obtain the result was ignored when exporting the data. So WYSI NOT WYG.

       

      Is there any way to use the workaround described by Joe and to send to Excel the values you see on the screen?

       

      Thanks!