Crystal Reports Accum

Technical Questions

Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions

Topic: Accum

Post Reply

Post New Topic

Author	Message
arsinfo Newbie Joined: 25 Jan 2011 Online Status: Offline Posts: 6	Topic: Accum Posted: 05 May 2011 at 10:08am
	How can i to do if want to divide the total of group1 by total of group2 or one value from detail divide by total of group1. I need to know the impact one product sales against total sales. Thank you Edited by arsinfo - 05 May 2011 at 10:08am
	IP Logged


freestylepunk Newbie Joined: 05 May 2011 Location: United States Online Status: Offline Posts: 13	Posted: 08 May 2011 at 5:59pm
	I assume your report looks something like this... Grouped by state & dealer: Sales amt % of state Dealer1 total 10 20% Dealer2 total 15 30% Dealer3 total 25 50% State total 50 100% You can try this formula: if Sum ({sales amt}, {statecodegroup}) > 0 then ({sales amt}/Sum ({sumup field}, {statecodegroup}))*100 else 0 Edited by freestylepunk - 08 May 2011 at 6:01pm
	IP Logged

arsinfo Newbie Joined: 25 Jan 2011 Online Status: Offline Posts: 6	Posted: 09 May 2011 at 2:02am
	Yes!, thank you very much....
	IP Logged

Printable version

Printable version

Forum Jump

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum