Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Percentage using distinct count and running total Post Reply Post New Topic
<< Prev Page  of 2
Author Message
fuller31
Newbie
Newbie


Joined: 29 May 2017
Location: United States
Online Status: Offline
Posts: 22
Quote fuller31 Replybullet Posted: 03 Jun 2017 at 3:03am
Originally posted by kevlray

FYI:  Distinct counts and grouping can be tricky depending on what you are counting on.  If there is chance that whatever you are counting on could end up in two different groups (i.e., a call number that could be in the called group and also in the cancelled group) would be counted only once in the report distinct count.

Well, my distinct count is counting call numbers. It's a simple summary of cdcall.number with a distinct count.
The running total summarizes field wrhistry.tencod and uses the formula {wrhistry.tencod} = "CANCL" to evaluate (because I want that to only show me the number of cancels) and resets on the change of the tow company group. So, there shouldn't be any kind of interference.
IP IP Logged
fuller31
Newbie
Newbie


Joined: 29 May 2017
Location: United States
Online Status: Offline
Posts: 22
Quote fuller31 Replybullet Posted: 04 Jun 2017 at 3:56am
I was playing around with changing some fields and figured it out. Instead of using a distinct count of cdcall.number, I used a distinct count of wrhistry.callid. The wrhistry.callid field is linked to cdcall.number. Using the formula below, I got it to work.

{#CANCL}%DistinctCount ({wrhistry.callid}, {tbwreck.desc})
IP IP Logged
<< Prev Page  of 2
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.