Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLUCIONADO

Average rows discarding Zero

prravich
Meteoro

Hi all,

 

I have a simple query and I am looking for a way to achieve it in a efficient manner. I have three columns marks 1 , marks 2 and marks 3 for students. I want to calculate the average of all three marks but if any of the marks says 0 , I need to ignore that and calculate average using only other two. Any help ?

 

StudentMarks1Marks 2Marks 3
A050100
B406050

 

Expected Answer:

studentavg_marks
A75
B50

 

1 RESPONDER 1
RodL
Alteryx Alumni (Retired)

Transpose data with Student as the Key field.

Use Summarize tool, group by Student and get Average - Ignore 0's (under Numeric)

Rótulos
Autores com maior número de soluções