0
Answered

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

Refeesh Aliyar 8 years ago updated 8 years ago 3


Hi,

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



Image 81

Answered

Hi,

this is the feedback forum for the new Community Profile. To ask a question like yours, the Community at https://answers.sap.com would be the perfect place ;)


anybody can help me for a solution

Hi Refeesh,

Please ask the question as Franz suggests and add the appropriate Crystal Reports tag as the Primary Tag (scroll down from the question's content). That should allow the correct subject matter experts to view your question.


Regards, Mike (Moderator)

SAP Technology RIG