Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: issue Post Reply Post New Topic
Author Message
kader
Newbie
Newbie
Avatar

Joined: 11 Jun 2012
Location: Qatar
Online Status: Offline
Posts: 18
Quote kader Replybullet Topic: issue
     Posted: 19 Nov 2012 at 1:38am
Please solve my issue
 
I have the following situation
 
Field 1                                    Field  2             Result field
 
100                                         1000
100                                         2000
100                                           -500                  2500
 
 
500                                         5000
500                                       - 5000                      0
 
so on. How can I fix a formula in result field to get this answer
 
 
IP IP Logged
comatt1
Senior Member
Senior Member
Avatar

Joined: 19 May 2011
Online Status: Offline
Posts: 337
Quote comatt1 Replybullet Posted: 19 Nov 2012 at 3:47am
Better to explain what you are looking to see as opposed to ONLY what you are seeing.
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 19 Nov 2012 at 10:27am
Use a running total that sums Field2 and resets when Field1 changes.
 
-Dell
Proviti, Data & Analytics Practice
www.protiviti.com/US-en/data-management-advanced-analytics
IP IP Logged
Sastry
Moderator
Moderator
Avatar

Joined: 16 Jul 2012
Online Status: Offline
Posts: 537
Quote Sastry Replybullet Posted: 20 Nov 2012 at 1:18am
Hi
 
Also you can create a group on Field1 and insert summary on Field 2.
Thanks,
Sastry
IP IP Logged
kader
Newbie
Newbie
Avatar

Joined: 11 Jun 2012
Location: Qatar
Online Status: Offline
Posts: 18
Quote kader Replybullet Posted: 22 Nov 2012 at 3:32am
Running total is fine . Cannot make a formula in another field ??
 
 
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 26 Nov 2012 at 4:03am
Originally posted by kader

Cannot make a formula in another field ??
 
What do you mean by this?
 
-Dell
Proviti, Data & Analytics Practice
www.protiviti.com/US-en/data-management-advanced-analytics
IP 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

HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | PRIVACY | CLICK PLAYS | KONACAD

© 2004-2026 Brian Bischof. All Rights Reserved.