BICS how to average on rows but not count zeros

Question

Summary

Content

How can I average on rows but the count will not count zeros?  Is this possible? example row1 = 100, row2 = 100, row3 = 0, and row4 = 0.  AVG does the math (100+100+0+0)/4=50.  I want it to skip "0" in the count of rows.  so something like (100+100+0+0)/2=100.  Excel has AVERAGEIF.

Madasamy -Oracle · Answer

You can use >0 on your case statement and proceed to calculate the AVERAGE for only the data >0.