Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: please help Post Reply Post New Topic
Author Message
aftershokk
Newbie
Newbie


Joined: 06 Apr 2010
Online Status: Offline
Posts: 11
Quote aftershokk Replybullet Topic: please help
    Posted: 06 Apr 2010 at 5:14am
It has been many moons since I used Crystal.

I have a basic rpt.

Column 1 sums unit_a in the report footer field = 6
Column 2 sums unit_b in the report footer field = 2

I have a formula in the report footer field to get a total of 8 units (6+2)

I want to divide column 1 total = 6 by the formula total of 8 to get 75% but I just cannot get it to work

please help!
Edit/Delete%20Message
IP IP Logged
saoco77
Senior Member
Senior Member


Joined: 26 Jun 2007
Online Status: Offline
Posts: 104
Quote saoco77 Replybullet Posted: 06 Apr 2010 at 6:09am
I think this should work

({@formula1}/({@formula1} + {@formula2}))*100

IP IP Logged
aftershokk
Newbie
Newbie


Joined: 06 Apr 2010
Online Status: Offline
Posts: 11
Quote aftershokk Replybullet Posted: 06 Apr 2010 at 6:25am
thanks I forgot the *100
IP IP Logged
Post Reply Post New Topic
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



This page was generated in 0.031 seconds.