average between 3 values result percentage

[VillitaDevelop]

Hi,

I have a table where I want to take the average of 3 values in percentage format. In my Google Sheet I have the formula which calculates what I want, but when I pass it to AppSheet I can't.

=IF(Y12=0,"",100%-AVERAGE(Y12:Y14))

Y12 =3.3 %

Y13=6.7 %

Y14=10 %

RESULT IS 93%

[lynchk21 · Accepted solution]

It seems a little odd to want to total the values in three consecutive rows (Y12:Y14), but if that is the goal maybe try:

• IF([_THISROW].[Y Column Name]=0,"",100-AVERAGE(SELECT(tablename[Y Column Name],AND([_RowNumber]<=[_THISROW].[_RowNumber]+2,[_RowNumber]>=[_THISROW].[_RowNumber]))))

Please let me know if I completely misunderstood

[VillitaDevelop]

Hi, 

thank you so much, I put this code and it worked, excellent!!!