1 of 1 people found this helpful
While you can't share your data, you should be able to share your data connection. Questions:
- What is your data source(s)?
- Are you connecting to multiple connections?
- Do you have any data filters in place?
- Are you connecting using Custom SQL? If so please post.
1. sql sever
2. multiple tables from same sql sever
3. except 'null' data
4. no Custom SQL, only 'Multiple tables'
Since you mentioned multiple tables. I removed / added 2nd table, issue resolved. But I don't get it, 2nd table has no actual numerical data, it simply reference data source. there isn't any calculation based on that data source.
Wendy, go to your original data connection (the multiple tables one) and then click Custom SQL. This opens up an editing box, click inside, click Ctrl-A, click Ctrl-C and then come back here an paste the results. Then we can talk about what might be going on, and why you're not getting the results you expected.
I figured out where went wrong. all because of 2nd reference table. which has duplicate account files on exactly the one has duplicate values. I kind understand, as 2 tables full joined so basically duplicated everything as they joined.
pass cautions along to my team, make sure this kind insane never happen again.
Thank you Shawn.
make sure this kind insane never happen again.
...but this is a very common issue in dealing with relational databases, and joins. So 'vigilance' is most definitely the watchword.
Happy you worked this out.