Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: Problem to calculate formula Post Reply Post New Topic
<< Prev Page  of 3 Next >>
Author Message
fsilvabrasil
Groupie
Groupie
Avatar

Joined: 08 Jul 2013
Location: Brazil
Online Status: Offline
Posts: 42
Quote fsilvabrasil Replybullet Posted: 10 Sep 2013 at 8:02am
This is what the friend, you have a solution to this problem.
IP IP Logged
fsilvabrasil
Groupie
Groupie
Avatar

Joined: 08 Jul 2013
Location: Brazil
Online Status: Offline
Posts: 42
Quote fsilvabrasil Replybullet Posted: 10 Sep 2013 at 8:04am
Originally posted by kevlray

I am reading over this thread and wondering how you got a decimal (3.373) when doing count?!?  Counts are always integer.






This is what the friend, you have a solution to this problem.
IP IP Logged
fsilvabrasil
Groupie
Groupie
Avatar

Joined: 08 Jul 2013
Location: Brazil
Online Status: Offline
Posts: 42
Quote fsilvabrasil Replybullet Posted: 10 Sep 2013 at 8:04am
This is what the friend, you have a solution to this problem.
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Quote kevlray Replybullet Posted: 10 Sep 2013 at 12:01pm
Apparently you are not doing a count, what kind of aggregation are you doing? 
IP IP Logged
fsilvabrasil
Groupie
Groupie
Avatar

Joined: 08 Jul 2013
Location: Brazil
Online Status: Offline
Posts: 42
Quote fsilvabrasil Replybullet Posted: 11 Sep 2013 at 1:59am
What I did was the formula below.

numberVar i: = 0;

if (AGR_FALTA_ATESTADOS_V.FALTAS {})> 0
   then i: = i +1


and put in the Group Footer # 3.

so that it shows the value 16 and not 10 that correct.
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Quote kevlray Replybullet Posted: 11 Sep 2013 at 6:15am
I am not sure what AGR_FALTA_ATESTADOS_V.FALTAS {} is (It does not appear to be the standard format for a field, running total, etc.).  Normally I use a running total to do counts and use a a formula to evaluate.

I hope this helps.
IP IP Logged
fsilvabrasil
Groupie
Groupie
Avatar

Joined: 08 Jul 2013
Location: Brazil
Online Status: Offline
Posts: 42
Quote fsilvabrasil Replybullet Posted: 17 Sep 2013 at 3:25am
Hello, Good Day

Someone else to help solve this problem.


Grateful to all.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 17 Sep 2013 at 3:35am
numberVar i: = 0;

if (AGR_FALTA_ATESTADOS_V.FALTAS )> 1
   then i: = i + (AGR_FALTA_ATESTADOS_V.FALTAS)

Edited by DBlank - 17 Sep 2013 at 3:37am
IP IP Logged
fsilvabrasil
Groupie
Groupie
Avatar

Joined: 08 Jul 2013
Location: Brazil
Online Status: Offline
Posts: 42
Quote fsilvabrasil Replybullet Posted: 17 Sep 2013 at 3:57am
Hello, Dear Friends

Yet the problem with your formula as use and put in Group Footer it brings no value. values ​​appear zero. and when do sum it shows zero not all right.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 17 Sep 2013 at 4:01am
lets make this easier
go to Running totals
right click
select new
name = SumGreaterOne
field to summarize=AGR_FALTA_ATESTADOS_V.FALTAS
type=sum
evlaute= use a formula
AGR_FALTA_ATESTADOS_V.FALTAS>1
reset=group1
place this RT in the group footer


Edited by DBlank - 17 Sep 2013 at 4:02am
IP IP Logged
<< Prev Page  of 3 Next >>
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.030 seconds.