Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Help with a formula

Hello community I would like your assistance with the following. I have 2 tables, they are related by "request type". I was able to count and present the # of request per analyst, but I am having is...
Need Help
Tips and Tricks
tarunsingla's avatar
tarunsingla
Solution Sage
6 years ago

Since the tables are already related, you can simply pull the Weightage field from your table1 into the visual and display the sum.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks a lot, Tarun. I tried and somehow it's showing like this:

     

    • tarunsingla's avatar
      tarunsingla
      Solution Sage
      6 years ago

      Can you double check that the relationship (1-*) exists between these 2 tables, on the Request Type field.

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Yes, it is there:

         

        ...but still shows the wrong number.... :smileyfrustrated: