Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Avg for 3 Pivot Table Expressions which are sometimes NULL

I am trying to get the average of 3 different expressions on a pivot table. These expressions are sometimes null thus I would want the average of the 2 or 1 that aren't null

Below there is a picture of the fields I am looking to get the average of. These fields change depending on the person I am looking at.

Eval Comp.JPG

0 Replies