Solved: Initial value = last entry recorded

Trevor_Jenkins1 · 01-12-2021 08:38 PM

Is it possible to write a formula for the initial value of a column to equal the value of the last entry in the same column?

In the example I am building the last entry will always be the highest value recorded and it will be the entry for yesterday in the date column which is also the keyid.

Thanks.

Suvrutt_Gurjar

In general you could use MAXROW() or MAX() expressions.

If you could share more precise details about the relevant columns and may be some sample data , meaning what is meant by the highest value - is it the same as the date column or some other column’s highest value, then the community could suggest a more appropriate solution.

View solution in original post

Suvrutt_Gurjar

In general you could use MAXROW() or MAX() expressions.

If you could share more precise details about the relevant columns and may be some sample data , meaning what is meant by the highest value - is it the same as the date column or some other column’s highest value, then the community could suggest a more appropriate solution.

Trevor_Jenkins1

The MAX() expression is exactly what I was looking for. I had been trying with the MAXROW() expression but only needed the column value and not the row. Thanks for your quick response. Slowly getting to grips with expressions!

Suvrutt_Gurjar

You are welcome. All the best wishes for your apps creation.