Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Adding quantity to a summary field... Post Reply Post New Topic
Author Message
Thad Tuck
Newbie
Newbie


Joined: 06 Feb 2015
Location: United States
Online Status: Offline
Posts: 4
Quote Thad Tuck Replybullet Topic: Adding quantity to a summary field...
    Posted: 21 Apr 2015 at 6:18am
This is my first time...
I am trying to create a formula that would add a quantity to a summary field based on a specific group header name and displaying the result...
Thaddeus
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 22 Apr 2015 at 6:58am
To do this, you'll create the summary in a formula. It will look something like this:

NumberVar numToAdd := 0;
If {group field} = 'Blah' then
numToAdd := 1
else if {group Field} = 'Blort' then
numToAdd := 2;
Sum({field to summarize}, {group field}) + numToAdd


-Dell
IP IP Logged
Thad Tuck
Newbie
Newbie


Joined: 06 Feb 2015
Location: United States
Online Status: Offline
Posts: 4
Quote Thad Tuck Replybullet Posted: 23 Apr 2015 at 7:41am
Hi Hilfy,
   It worked... Sweeettt... Thank you very much...
     Thad

Thaddeus
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.016 seconds.