Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: subtotal of rows (formula) Post Reply Post New Topic
Author Message
tods
Newbie
Newbie


Joined: 27 Aug 2011
Online Status: Offline
Posts: 1
Quote tods Replybullet Topic: subtotal of rows (formula)
     Posted: 27 Aug 2011 at 8:14pm
hi guys,
 
i'm new here. need help sorting this out. (cr xi)
 
i've 3 formula fields that check on condition and return 1 if true
then, i've created 3 summary (sum) and placed it no group header
 
group     #sum of @field1#     #sum of @field2#     #sum of @field3#       X
a                     2                                  2                              3
b                     1                                  1                              2
c                     3                                  4                              9 
 
 
i'm trying to create another row 'X' which sum({@field1,2&3}) / 30 but failed.
 
appreciate your kind assistance
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 29 Aug 2011 at 3:51am
one was is to write a new formula with 3 if statements added together and then sum it at the group level)
(if field1=True then 1) + (if field2=True then 1) + (if field3=True then 1)

Edited by DBlank - 29 Aug 2011 at 3:51am
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