Forum Discussion

MichalHoltz's avatar
MichalHoltz
Frequent Visitor
9 years ago
Solved

How to do an average of multiple columns?

I have 3 columns and would like to get the average of 3 of them. How do I do that? App1 App2 App3 1 2 1 3 2 1 2 3 5 3 4 5 5 4 3 2 5 4
  • vanessafvg's avatar
    vanessafvg
    9 years ago

    MichalHoltz you right!

     

    what about 

     

    (AVERAGE(Table2[SAP SRM Functionality])+average(Table2[SAP SRM Productivity])+average(Table2[SAP SRM Quality])+average(Table2[SAP SRM Support]))/4?

     

     

vanessafvg's avatar
vanessafvg
Icon for Community Champion rankCommunity Champion
9 years ago

MichalHoltz you right!

 

what about 

 

(AVERAGE(Table2[SAP SRM Functionality])+average(Table2[SAP SRM Productivity])+average(Table2[SAP SRM Quality])+average(Table2[SAP SRM Support]))/4?

 

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

This doest work if one value is missed or 0 - may be any solutuon for that?

 

thnaks

ALeks

  • Cre8's avatar
    Cre8
    Regular Visitor
    3 years ago

    Exactly. Is there a way to solve this problem? Have the same problem!