Skip to Content

Crystal report formula-Need to Make sub total for one Group number to another group

Oct 20, 2016 at 10:41 AM


avatar image
Former Member


I am creating a report using crystal report to find out Actual and Theoretical cost for our product. My main core output is variance total and variance percent per stores. To finding the variance there is a changes in calculation. The calculation for variance cost is the absolute value of the variance quantity * cost. So when I am doing this calculation per line item in “detail” area will not be accurate , thus, I made the calucation in my item Group by formula. Now I need to make the total for that group formula to another group as store. How can I do it , please advise me.

In order to solve the issue for the calculation I added one formula but it is accumulating all item value for all stores. I cannot separate it based on stores by item in the formula ,otherwise it will work fine. Formula ie;

numbervar SumSales;

SumSales := SumSales+{@absv} ;

I hear by attaching the report for your reference

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

avatar image
Former Member Oct 23, 2016 at 06:11 AM

waiting for reply

10 |10000 characters needed characters left characters exceeded