0

Seelect where Calculation from 2 entries

Hello i ned the difference from 2 entries in a table (Hour meter)

the last of the entry i get: 

 

 let myreg := Registration;
last((select 'Flt Hrs' where Luftfahrzeuge.Registration = myreg) order by Datum).TSN

but for calculation i need also the secon last of the same Registy... how can i solve this?

 

Table 'Flt Hrs'

 regards Alex

2 replies

null
    • Fred
    • 6 hrs ago
    • Reported - view

    I'm not sure what you are asking. Your code finds the last record of a dataset then gets the data from the TSN field. Are you asking how to get other data from the same field?

    • Ninox partner
    • RoSoft_Steven.1
    • 5 hrs ago
    • Reported - view

     Try:

    let myreg := Registration;
let sel := (select 'Flt Hrs' where Luftfahrzeuge.Registration = myreg) order by Datum)
item(r, cnt(sel) - 2).TSN
Login to reply

Content aside

  • 5 hrs agoLast active
  • 2Replies
  • 9Views
  • 3 Following