Forum Discussion
Issues with a relationship created
Hi,
I have created a relationship in my data set where the tax id information from mutliple data sources are set on a cross directional relationship. I am running up against issues though when the tax id number isnt in the data set it sums up all the information from all payment amounts that have a blank tax id number... For instance, I funded $10,000 to Sally Corp in 2016 and that $10,000 shows up correctly. However, I didnt fund anything to Nancy Corp so it sums up all payments were the tax id is blank or not present into a large $1,000,000 payment (which is the representation all payments where we didnt fund a specific organizaiton previously). Anyone ever ran into this issue?
I hope this makes sense.
Thanks for the assistance! I figured it out. It was because my relationships are setup by a different criteria and it was pulling in the amount. I think for now the answer is to remove that field or create a duplicate of the data set and create new relationships to pull in this one field.
7 Replies
nmck86 what are you expecting it to rollup into if the id is blank?
$0
nmck86 so what do you want to do with the data that doesn't have an id and has a value? hide it?
is it possible to provide screen shots?
Hi nmck86,
Can you share sample data about those tables which has relationship between? Which common field dis you use to create the relationship?
Best Regards,
Qiuyun YuThanks for the assistance! I figured it out. It was because my relationships are setup by a different criteria and it was pulling in the amount. I think for now the answer is to remove that field or create a duplicate of the data set and create new relationships to pull in this one field.
