4 Replies Latest reply on Aug 29, 2018 1:47 PM by Shinichiro Murakami

# Creating an Avg

Sheet 3 in the attached workbook. I need to create an avg score, using the measure Avg Score, based on Score, ADH Score, QA Score for Care Agents and Score, ADH Score, QA Score, and AOV Score for Sales Agents. I'm not sure how to get it to average. I tried dividing it by 3 and 5 but that doesn't work. They should read as 3.0, 3.8, and 3.2.

IF ATTR([Agent LOB]) = "Care Agent" THEN [Score]+[ADH Score]+[QA Score]

ELSEIF ATTR([Agent LOB]) = "Sales Agent" THEN [Score]+[ADH Score]+[QA Score]+[AOV Score]+[Close Rate Score]

END

Thank you,

Barb

• ###### 1. Re: Creating an Avg

Not exactly sure but you means this?

Thanks,

Shin

• ###### 2. Re: Creating an Avg

Hey Shin,

Sorry, I had to make an edit to the formula right after I posted. There should be an updated workbook. When I divide by the 3 and 5 I get this:

• ###### 3. Re: Creating an Avg

Ooooh I see what you did! You put in parenthesis around the items I'm adding together. I tried that and it worked. Thanks!

• ###### 4. Re: Creating an Avg

Glad that I could help you.

Thanks,

Shin