Forum Discussion

jjmauras's avatar
jjmauras
Icon for Advocate II rankAdvocate II
10 years ago
Solved

Multiplying between Tables

This seems like it should be an easy objective but I cannot figure it out. Any help is appreciated. All I want to do is create a New Column that multiplies 2 different rows. The rows exist in two di...
  • Anonymous's avatar
    Anonymous
    10 years ago

    Just to clarify on 1 to many relationships:

     

    * From the "Many" side, you can use RELATED(OneSideTable[Field]) just fine.  As there is... only 1 row that will match.

    * From the "One" side, you can use RELATEDTABLE(ManySideTable) as get all rows associated with the one side... and do something w/ those rows.  eg:  =SUMX(RELATEDTABLE(ManySideTable), ManySideTable[Price])

     

jjmauras's avatar
jjmauras
Icon for Advocate II rankAdvocate II
10 years ago

I figured out the problem. For future reference. I have a Many-to-One relationship between these tables.

 

One - p21_view_mt_pix_tix_detail

Many - p21_view_oe_line

 

I was unaware you can not call a Many table into a One table. I'm pulling everything into the Many table and that seems to be working for me.

 

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Just to clarify on 1 to many relationships:

 

* From the "Many" side, you can use RELATED(OneSideTable[Field]) just fine.  As there is... only 1 row that will match.

* From the "One" side, you can use RELATEDTABLE(ManySideTable) as get all rows associated with the one side... and do something w/ those rows.  eg:  =SUMX(RELATEDTABLE(ManySideTable), ManySideTable[Price])

 

  • gbarredap's avatar
    gbarredap
    Regular Visitor
    9 years ago

    I need a similar solution but I have Many to Many relationship.