Most recent value of a column

[#1]

Post edited by Community Team member:

Please post in English unless in a dedicated language section.

Post translated by Google translate

---

Hello everybody,

I would be glad if someone could help me advance my project.

I just create a program for monitoring of health data.

The goal is a statistics table / better than individual text fields

Identification presentValue AVG MAX MIN

weight

waist

AVG MAX MIN are no problem.

But how do I get the most current value of the weight column?

And like a TextBox with the date to the value MAX Weight?

Many thanks for your help.

[#2]

You can use Firstsortedvalue function to get the latest Weight with date time

firstsortedvalue (Weight,-<datefield>)

[#3]

Hi, thank you but this doesnt work. It Returns -

[sunny_talwar]

Try with Distinct may be:

FirstSortedValue(DISTINCT Taille, -DateField)