Skip to Content
Former Member
Oct 20, 2016 at 10:41 AM

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

90 Views Last edit Sep 04, 2017 at 09:37 AM 2 rev


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