Forum Discussion

davide00's avatar
davide00
Frequent Visitor
8 years ago
Solved

Existing relationship not working

Hi All,

 

I have two tables that share a common field "project code". in order to associated them (they have duplicates in them), I created a third table containing only one column "prject code" without errors nor duplicates. I have then created the relationship between these three tables. However, whenever i tried to combine the data from the two main tables, I always get an error message 'cant display the visual'. 

 

How can I solve it?

 

Thanks!

 

 

Need Help
  • MFelix's avatar
    MFelix
    8 years ago

    Hi davide00,

     

    seems to me that your problem is that the Actuals value in the Detail analysis is in the wrong format as you can see in the values you have First Actuals if this is a number you should have sum but since you dont have the E simbol on your table it means that your information is as text and not number.

     

    Check the formating of the columns.

     

    Regards,

    MFelix

     

6 Replies

  • MFelix's avatar
    MFelix
    Super User
    8 years ago

    Hi davide00,

     

    be aware that to combine the information from this tables you need to use in the visuals the project code that you made in the table withouut duplicates and not any of the other project codes columns. 

     

    Regards,

    MFelix

    • davide00's avatar
      davide00
      Frequent Visitor
      8 years ago

      Hi Felix,

       

      Thank you for your help.

       

      However, despite selecting the project code from the new table, whenever I tried to combine data from the indirectly linked tables, I got an error. 

       

      Any other mistake I could have made?

       

       

      • MFelix's avatar
        MFelix
        Super User
        8 years ago

        Can you explain and add a small print of hwat you want to achieve?

         

        Regards,

        MFelix