Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
4 years ago
Solved

Average between columns

Hello all I need a help that maybe is simple but I have already watched several videos and forus and it does not work for me. I need to create a column that calculates the average of the 5 colunmas ...
  • SolomonovAnton's avatar
    SolomonovAnton
    4 years ago

    hello 

     

    I think it will help you:

     

    calculation column = 

var _Y1 = if([Y1]=0,blank(),[Y1])

var _Y2 = if([Y2]=0,blank(),[Y2])
var _Y3 = if([Y3]=0,blank(),[Y3])
var _Y4 = if([Y4]=0,blank(),[Y4])

var _Y5 = if([Y5]=0,blank(),[Y5])

var _result = (_Y1+_Y2+_Y3+_Y4+_Y5)/(_Y1/_Y1+_Y2/_Y2+_Y3/_Y3+_Y4/_Y4+_Y5/_Y5)
return _result

     

SolomonovAnton's avatar
SolomonovAnton
Super User
4 years ago

hello 

 

I think it will help you:

 

calculation column = 

var _Y1 = if([Y1]=0,blank(),[Y1])

var _Y2 = if([Y2]=0,blank(),[Y2])
var _Y3 = if([Y3]=0,blank(),[Y3])
var _Y4 = if([Y4]=0,blank(),[Y4])

var _Y5 = if([Y5]=0,blank(),[Y5])

var _result = (_Y1+_Y2+_Y3+_Y4+_Y5)/(_Y1/_Y1+_Y2/_Y2+_Y3/_Y3+_Y4/_Y4+_Y5/_Y5)
return _result