6 Replies Latest reply on Apr 7, 2016 9:38 AM by Ian Johnson

# Measure Values are being multiplied by 10

I am really having a hard time understanding why the value is not displaying apples to apples.  For this example (Anderson, February 2016, gross revenue is showing 74.5M in both the excel data sheet, and tableau data, however when I bring that in to tableau sheets it is multiplying by 10 resulting in 745M. The only way I can get the actual result that I need is by changing "SUM" to "MAX". However, that solution will not work for me because I will need to show the aggregated data into the Region as well.

I've attached screenshots, but can attach a workbook if you need it.

Is there a know issue? or can someone please point me in the right direction here.

Thanks!

Ian

Ian,

Josh

• ###### 2. Re: Measure Values are being multiplied by 10

You don't see the three screenshots i've attached?  hmm...

• ###### 3. Re: Measure Values are being multiplied by 10

Hi Ian,

It looks like you are experiencing data duplication due to joins.

The reason behind this is that the two tables are not a 1:1 relationship. Instead, one of your tables has many values that match another. For example, while you may only have 1 value for Cincinnati in Table A, you may have 10 values for Cincinnati in Table B. Table joins will fill in the corresponding information for all rows matching the join column.

The easiest way around this is an LOD calculation. Something similar to:

{Include [City]: MAX(Sales)}

A more in-depth article can be found here: Top 15 LOD Expressions | Tableau Software

Hopefully this helps!

• ###### 4. Re: Measure Values are being multiplied by 10

I didn't join any tables, but the LOD Calculation you suggested seems to work. THANKS!

• ###### 5. Re: Measure Values are being multiplied by 10

I do see them now. For whatever reason the view I had earlier didn't show them.  Anyways, I'm not sure this is data duplication per say.  it seems to be and even 10x difference.  Which might suggest that a data type was mapped incorrectly.  I can see it is set as a number in Tableau but I'd need to take a look at a packaged workbook to be able to identify why the 10x multiplier is happening if you didn't create any joins in your connection.

Josh

• ###### 6. Re: Measure Values are being multiplied by 10

Thanks for the feedback Josh.  I don't have any joins, and have never had this issue before. I've found two workarounds for this, the LOD Calc from above works, also a calc that divides the measure value by 10 works as well. If these solutions hit a dead end somewhere down the line I'll attach my workbook.

Thanks!

Ian