Summing a field for several periods

[betmck]

I want to sum up the field call cost for all periods less than and equal to the period chosen. For example, the table information is as follows:

PeriodID Cost
0 200
1 100
2 200
3 100
4 200
5 600


Therefore, if period 4 is chosen then I want to sum the cost for period 4, 3,2,1 and 0. How can I do this in Crystal?

[jggtz]

You could try inserting a RunningTotal and the condition (choosen period) could be an input parameter or a formula