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 ...
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])
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])
  • erhan_79's avatar
    erhan_79
    Post Prodigy
    6 years ago

     perfect!! Greg_Deckler  thank you very much!