About Average Formula Problem

[janchinkhai]

How to sum all the score, which is select type, and divide to get the average? just like I get (0.5+0.5+0.5) / 3=… but I want NA not to be calculated like I have NA, 0.5, 1 I want the formula is (1+0.5) / 2=0.75 . Could someone help me?

[Tivisah]

Hi, you may refer to this

Block - Calculate Total Using Select Type & Calculate Average

Question: How to sum all the scores, which is a select type, and divide to get the average? if select NA is not to be calculated. For Example, I have 3 table lines the option I select is 1,0.5 and NA. so, Total = 1.5 Average = total / 2 table lines (exclude NA line) = 1.5/2 = 0.75 Calculate Total Using Select Type Let me show you how to do it in the Automation block. Go to the Default form Open and Scroll all the way and Click Add Automation Drag & Drop For block [image] I…