Skip to main content
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
CRS1
Contributor
Contributor

Values doubling

Good afternoon, 

 

I am having some trouble with a set of data.  When I import the data, all of the data is coming through correctly, except a few numbers.  The numbers that are not coming through are either doubling or quadrupling in value.  How can I resolve this issue? 

 

Thanks for any and all help. 

3 Replies
Or
MVP
MVP

Check that your joins are correct. Duplication of values typically suggests you have e.g. a 2:1 relationship between two of the tables involved in your calculation (or 4:1 if quadrupled, etc).

CRS1
Contributor
Contributor
Author

When you say "joins", what does that mean?
Or
MVP
MVP

Generally, anything that connects values from two (or more) tables can cause this sort of duplication. It might be a key between two individual tables, it might be two tables that are explicitly joined into one, etc.

Community Browser