Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Running total field missing my formula Post Reply Post New Topic
Author Message
Bill13
Newbie
Newbie
Avatar

Joined: 11 Oct 2012
Online Status: Offline
Posts: 9
Quote Bill13 Replybullet Topic: Running total field missing my formula
     Posted: 11 Oct 2012 at 1:25pm
Hi Experts,
 
 In crystal Report 2008 I am trying to do a running total to show in detail section right next to my actual column.
 
Actual is calculated by a formulla
Actual = {ZISM.[Measures]-[123456789]}/{@Total__Sales_CYTD})* 100
 
Actual    cumulative should be
1.1                  1.1
1.2                  2.3
1.3                  3.6
 
Now when i click on Running total and try to make running total of this column it does not list me this perticualr formula.
 
Can someone make me this formula?
 
i have tried this but it is giving me same numbers instead of running total.
 
WhilePrintingRecords;
NumberVar GR;
GR :=
{ZISM.[Measures]-[123456789]}/{@Total__Sales_CYTD})* 100
;
 
 
Many thanks in advance.


Edited by Bill13 - 11 Oct 2012 at 1:40pm
Bill
IP IP Logged
Sastry
Moderator
Moderator
Avatar

Joined: 16 Jul 2012
Online Status: Offline
Posts: 537
Quote Sastry Replybullet Posted: 11 Oct 2012 at 10:37pm
Hi
 
You are almost there, try this :
 
WhilePrintingRecords;
NumberVar GR;
GR := GR+{ZISM.[Measures]-[123456789]}/{@Total__Sales_CYTD})* 100;
 
 
 
 
Thanks,
Sastry
IP IP Logged
Bill13
Newbie
Newbie
Avatar

Joined: 11 Oct 2012
Online Status: Offline
Posts: 9
Quote Bill13 Replybullet Posted: 12 Oct 2012 at 2:32am
Thank You Sastry ,, Yes this resolved my issue.
Bill
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