I believe that the best way to accomplish this is to set up two calculated fields that handle the determination of which values meet the requirements listed above. In the attached workbook I have created these two fields as Cumulative Cash Flow (Values between Start and End Date) and Start Market Value (Market Value at Start Date).
Hope this helps.
Date Param Calc 209521.twbx 249.8 KB
thanks Benjamin, works perfectly.