I have a report with rows which look like this:

Customer, Number Ordered, Number Received, Number Returned
Bob, 3, 1, 0
Susie, 8, 7, 3

At the bottom of the report, I have a summary row with the total number ordered, total number received, and total number returned. I use a pentaho report designer function called "Sum(Running)" to calculate these totals. The last row looks like this:

Customer, Number Ordered, Number Received, Number Returned
Total, 11, 8, 3

I now want to add a total percent returned which will be the (Total Number Received) / (Total Number Returned). However, when I enter it into the formula expression, I always get 0 back as the result.

Can a formula reference another formula (since my total number received is calculated by formula X and total number returned is calculated by formula Y)? Or is there something else that might be wrong?

Thanks.