Hello, I’m trying to bring the fuel price from the “Preturi combustibil” to the “Registru Productie” according to the last entered date and the car’s registration number. My problem is that the car is not refueled at the gas station every day and when the date is between the 2 refueling (for examp…

I think a query with with conditions to match, License Plate is This Row → License Plate l, and Date is on or before This Row → Date, should work. Set the query sorting to sort ascending by date and only return 1 row. Then use a Single Value column to retrieve the fuel price from the query.

Query problem

Ask for Help

Darren_Murphy January 28, 2024, 8:34am 3

Isn’t this basically the same problem that we already solved below?

Topic		Replies	Views
Formula to show the latest fuel price? Ask for Help	12	216	December 11, 2022
Filter data components Ask for Help	13	178	January 30, 2024
Function yesterday Ask for Help	7	104	January 17, 2024
Lookup item in another table based on date selection in target table Ask for Help	1	203	December 27, 2022
Get last price for collection from all the listings Ask for Help	3	224	November 28, 2023

Query problem

Related topics