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

techies's avatar
techies
Super User
1 year ago

Hi PC2022 please check this

 

ScheduleAvg =
AVERAGEX(
    crb87_consultantevaluation,
    VAR NonBlankCount =
        COUNT(crb87_consultantevaluation[Timeliness of Phase Submittals (A)]) +
        COUNT(crb87_consultantevaluation[Timeliness of Deliverables (C)]) +
        COUNT(crb87_consultantevaluation[Timely Submittal of Reports (B)])
   
    VAR TotalValue =
        crb87_consultantevaluation[Timeliness of Deliverables (C)] +
        crb87_consultantevaluation[Timeliness of Phase Submittals (A)] +
        crb87_consultantevaluation[Timely Submittal of Reports (B)]

    RETURN
        IF(NonBlankCount > 0, TotalValue / NonBlankCount, BLANK())
)
  • PC2022's avatar
    PC2022
    Helper III
    1 year ago

    it is returning the same number for each project and phase