Avg List

[cmunozro]

I have  a virtual column, which calculates the difference from its predecessor value

[DifCasaCaseros] = [CasaCaseros]-LOOKUP([_THISROW].[_RowNumber]-1, "Depositos Agua", “_RowNumber”, “CasaCaseros”)

The 1st row computes 0, because the is no previous data from where to subtract. The thing is that I want also to know the AVG from [DifCasaCaseros], but as the 1st data is 0, it kind of perverts the result.

How should I do it?

[Suvrutt_Gurjar]

What expression you are using for average?

[cmunozro]

AVG

[Suvrutt_Gurjar]

Thank you. AppSheet has AVERAGE() function. There is no AVG() function in AppSheet.  May I request you to let us know the expression you are using for coming up with average so that teh community could help you with better solution?

In general, the approach will be to remove the 1st row from the expression.

https://help.appsheet.com/en/articles/2347636-average

[cmunozro]

OK. And how do I remove the first row? How do you manage ranges within a column?

[graham_howe]

You could just filter based on the _RowNumber