Hello, I'm having trouble with the syntax to avg multiple values.
I have the below values and I want to exclude VTO and UTPO values in my avg expression. I would like to see both in chart and in script...Thanks in advance.
=avg(if(REASON = '',''))
I have a column "Reasons" that has about 30 values within that column. I want to avg only certain values within the Reasons column.
Reasons ID (thds of values) Value
OT (include in AVG) 1 10
PTO (include in AVG) 2 20
VTO (exclude in AVG) 3 30
UTPO (exclude in AVG) 4 40
Got it! One more question
I have two conditions that I need met. The 2nd, Status = Closed. Can that be added in the expression?