Ref - How to get the last low row

[chocolate]

I want to get the last low value in a table, but i can't. It only get the low value this year. Any one can help me please?

I'm using this expresion now

MINROW("Table",
      "Column", AND(
                  ([element] = [_THISROW].[name]),
                  ([date] >= DATE("1/1/" & YEAR(TODAY())))
                 )

)

[dbaum]

---

@chocolate wrote:

the last low value in a table

---

It's unclear what you mean by this.

Did you try either of the following? Does one of these return the value you need?

MINROW("Table", "Column", [element] = [_THISROW].[name])

MIN(Table[Column])

If you need more assistance, you should post screenshots of your table's list of columns and an explanation of what value you want to return from which column and where in your app you need to return that value.

[MultiTech]

Whenever I see things like this:

... it's typically because there's a missing reference connection
      - or it's there, it's just not being used for whatever reason.

If you connect things together with references, then you get a reverse reference on the parent level - this, contains all the related records.

• From that ref_rows() column, you can then list dereference all the values and pull the last one
  • The benefit here is there's no brute force re-query of your database to get the answer; it's simply extracted from the data already present in the system.

index(
  [Related Whatevers][Item], 
  count([Related Whatevers][Item])
)