Forum Discussion

erhan_79's avatar
erhan_79
Post Prodigy
6 years ago
Solved

Avarage Calculating

Hi There ;

 

İ need to calculateof Avarage Qty of each vendor's in another table as column

 

İ have a sheet as below 

 

 

and i have a table as below 

 i want to create a column on   above table which gives " avarage "  of qty for each vendor as below : 

 

 

 

 

thanks in advance 

 

 

Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    Let's call your tables Table1 and Table2.

     

    Relate Table2 to Table1 on Vendor Name column.

     

    In Table2, create this column:

     

    Column = AVERAGEX(RELATEDTABLE('Table1'),[Qty])

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    6 years ago

    Let's call your tables Table1 and Table2.

     

    Relate Table2 to Table1 on Vendor Name column.

     

    In Table2, create this column:

     

    Column = AVERAGEX(RELATEDTABLE('Table1'),[Qty])