Calculated Expression with Variables, Excluding Nulls

[cm]

Probably a simple question and answer, but I'm trying to get an average of three variables, excluding null values from two of them. Looks like this...

Avg({<[COMPEX Score] -=null>}, <{OFTD Score] -=null>}, [Search Score])

Each of the "scores" are set variables.

Any help?

[Zhandos_Shotan · Accepted solution]

Try this

Avg({<[COMPEX Score] ={"*"}, [OFTD Score]={"*"}>} [Search Score])

[cm]

Zhandos,

I marked yours as the solution, but the expression you sent is actually only returning Avg([Search Score]). Why do you think that is?

[Zhandos_Shotan]

Hi,
I dont understand this: Each of the "scores" are set variables
Can you provide example file?

[cm]

Zhandos,

The file contains sensitive info so I can’t send it, but the scores are just variables I created. I think I’ve figured it out. Thanks for the attention. CM