Forum Discussion
How to report last value available
Hello, I have one table called 'Cast' with: Project Date bFP A 01-01-2021 100 A 01-05-2021 120 Then I have the 'Cal...
ryan_mayu
Super User
Super Userhow does your calendar table look like? only have 5 dates?
why all the bPF are 100, no 120?
Hello, thanks.
Calendar contains all the dates, one for each day/month/year.
My results is (error in previous post):
Date bFP Project
Jan-21 100 A
Feb-21 A
Mar-21 A
Apr-21 A
May-21 120 A
Expected results are:
Date bFP Project
Jan-21 100 A
Feb-21 100 A
Mar-21 100 A
Apr-21 100 A
May-21 120 A