Good day Everybody,
This is my first time here. I was wondering if anyone can help me with this problem in Crystal Report. I have created a report using a Access table and inserted a subreport using a different table and linked it to the intial table. Link is fine. It shows proper record for each customer. I basically have a few fields in the second sureport table: (X =Total products), product distribution A, B and C. I have created a field =sum(A)/sum(X) for each distribution fields to get a percentage for each field. When I preview the report, the calculated fields doesn't work. It doesn't show the real calculated value. When I created this report separately. The values are correct. What is it that I am doing that's wrong. Any help is greatly appreciated.

Thanks very much.