topic Re: Only the most recent line in App Development

Only the most recent line

JoepF2 — Thu, 02 Mar 2023 09:04:28 GMT

Hi,

Excuse me if I might have used the wrong location.

My question is about three dimensions which show the price of the rentalcontract over the years. My wish is that the dimensions only show the most recent year/pricerow, which is €61.211,04, €193,20 & €61.404,24. (see picture below). Now it shows all of the price history, but I only want the most recent (or current) price.

What is the most efficient way to generate this wish? I have little to less experience with programming. What information do you need from me to generate the formula?

Thanks in advance.

Re: Only the most recent line

Gabbar — Thu, 02 Mar 2023 10:08:19 GMT

Knowing the names of column would help a lot,
but let me try here
these are prices so lets name these three field A,B,C
Now these are prices of something suppose that thing details is in Field D (These can be multiple column rather than single you can consider all of those merged here using '&')
Now as you have asked for latest Price only then there must be date field in the Table lets name that column F.
So try this:
Table1:
Load A,B,C,D,E ,A&E as Key from Source;
inner join
Load A&E as Key;
Load A,max(E) as E resident Table1 group by A;

Re: Only the most recent line

JoepF2 — Thu, 02 Mar 2023 15:04:04 GMT

Hi @Gabbar ,

Thanks for replying.

The first column is called: =[Aanhuur.NettoHuur]
The second column is called: =[Aanhuur.Servicekosten]
The third column is called: =[Aanhuur.BrutoHuur]

The columns are indeed linked by a date field, which is called: =[Aanhuur.DatumVan]

Could you perhaps repeate yourself and the steps with the column names?

Re: Only the most recent line

Gabbar — Fri, 03 Mar 2023 04:40:37 GMT

there must be 1 more column, These are prices of something(like Bread,Electronics etc) what is the name of that column.

Re: Only the most recent line

JoepF2 — Fri, 03 Mar 2023 07:55:45 GMT

@Gabbar

It's linked to the column: =[Huurinfo.Huurcontract]. It's the contractnumber.

Re: Only the most recent line

Gabbar — Fri, 03 Mar 2023 09:00:52 GMT

Are all these field same table,
Please add a snapshot of Table of all columns .

Re: Only the most recent line

JoepF2 — Fri, 03 Mar 2023 09:15:26 GMT

No it's not.

Here's the snapschot:

Re: Only the most recent line

Gabbar — Fri, 03 Mar 2023 09:23:27 GMT

Snapshot of table as sample data, Not load editor,:
Let me try again :
The field name is Objects whose prices are given for different time period.
Now:
Table1:
Load Objects,[Aanhuur.NettoHuur],[Aanhuur.Servicekosten],[Aanhuur.BrutoHuur],[Aanhuur.DatumVan]
,Objects&[Aanhuur.DatumVan] as Key from Source;
inner join
Load Objects&[Aanhuur.DatumVan] as Key;
Load Objects,max([Aanhuur.DatumVan]) as [Aanhuur.DatumVan] resident Table1 group by Objects;

This Data is of something, (Mostly The primary key of table).