Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: counting condition Post Reply Post New Topic
Author Message
taniarto
Groupie
Groupie
Avatar

Joined: 15 Oct 2010
Online Status: Offline
Posts: 52
Quote taniarto Replybullet Topic: counting condition
     Posted: 21 Nov 2011 at 8:36pm
I Have report like this

Nu.     PO           Order           Delivered            Status
1.     001            10                 5                      Open
2.     002            5                   5                      Closed
3.     003            3                   3                      Closed
4.     004            2                   0                       Open

I need to create summary information like :

Total
-  PO :   4
- Closed  = 2
- Open    = 2

Status is from formula (Order-Delivered >0 then Open Else Close)

Thanks a lot,



IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4374
Quote lockwelle Replybullet Posted: 22 Nov 2011 at 3:23am
hmmm,
PO, simple count
 
for the open or closed, DBlank would do something like:
if Ordered - Delivered > 0 then 1 else 0
 
and then he would Sum the formula, this give the number of open POs.
 
last subtract the Count of POs from the number of opens.
 
HTH
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