Thanks - thats a great help. Do you know how to calculate the number of days between the lines?
Hmmm stumbled around for a while but "can't bring the finger behind the trigger"
Based on if [Sales cumm.]>=1000 then attr([Date]) END I can find the first date above 1000 but can't capture it to calculate further with.....
Shinichiro Murakami could you step in and guide on this challenge?
Your assistance is appreciated.
We already solved this challenge offline, but I'm posting the solution here so that other people can benefit from it (solution workbook is attached).
First, you have to create 3 parameters that serve as benchmarks and allow for dynamic input from the user (you can change the values by typing in).
Then, we have to create 3 tests that check whether the running sum of sales has reached the respective benchmark.
After that, you have to calculate the dates when the benchmark was reached (see Date Test and Date Benchmark calculations).
Lastly, using a datediff calculation you can find the exact number of days.
Please flag this post as answered. Thanks!