Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey,
I have Master table with Article, Date and Price [Prices].
On the other hand, I have a table with Article an Date [Transaction]
What I want to do is to get the last known price and date from [Prices] for each article where a [Prices].Date <= [Transaction].Date.
Can anyone help?
Solution will be welcome to solve this in an expression but also with scripting.
Thanks
You can find a scripting solution in the QV Cookbook example "Fill values in a data range using previous values".
-Rob