Forum Discussion

PC2022's avatar
PC2022
Icon for Helper III rankHelper 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

pankajnamekar25's avatar
pankajnamekar25
Icon for Super User rankSuper User
1 year ago

Please try this

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

PC2022's avatar
PC2022
Icon for Helper III rankHelper III
1 year ago

Not working either