Forum Discussion

PC2022's avatar
PC2022
Helper III
1 year ago
Solved

Calculating average between several columns

Trying to calculate the average number between 3 columns. I get an error "the count function only accepts a column reference as an argument"   ScheduleAvg = (AVERAGE(crb87_consultantevaluation[crb...
  • pankajnamekar25's avatar
    pankajnamekar25
    1 year ago

    Please try this

    ScheduleAvg =
    (
    AVERAGE(crb87_consultantevaluation[crb87_timelinessofprojectphasesubmittalsd]) +
    AVERAGE(crb87_consultantevaluation[crb87_timelysubmittalofprogressreportsandschedud]) +
    AVERAGE(crb87_consultantevaluation[crb87_timelinessofprojectphasedeliverablesandord])
    ) / 3

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi PC2022,

 

As suggested by the super user, please provide sample data that demonstrates your issue, along with the expected outcome. This will help us better understand the problem and provide the right guidance to resolve it.

 

Regards,

Vinay Pabbu