What I want to do
taking the avg
of multiple value variables A
, B
, C
What I did
I could do this as
countA as count(val(A))
countB as count(val(B))
countC as count(val(C))
avgA as avg(val(A))
avgB as avg(val(B))
avgC as avg(val(C))
final_result: math( (avgA*countA+avgB*countB+avgC*countC)/(countA+countB+countC))
but I’m hoping for something simpler, like :
final_result: avg(A, B, C)
which doesn’t work