Crystal Reports Problem to calculate formula

Technical Questions
Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions

Topic: Problem to calculate formula
	<< Prev Page of 3 Next >>

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

fsilvabrasil Groupie Joined: 08 Jul 2013 Location: Brazil Online Status: Offline Posts: 42	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 Logged

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

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

fsilvabrasil Groupie Joined: 08 Jul 2013 Location: Brazil Online Status: Offline Posts: 42	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 Logged

kevlray Admin Group Joined: 29 Oct 2009 Online Status: Offline Posts: 1587	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 Logged

fsilvabrasil Groupie Joined: 08 Jul 2013 Location: Brazil Online Status: Offline Posts: 42	Posted: 17 Sep 2013 at 3:25am
	Hello, Good Day Someone else to help solve this problem. Grateful to all.
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	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 Logged

fsilvabrasil Groupie Joined: 08 Jul 2013 Location: Brazil Online Status: Offline Posts: 42	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 Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	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 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.016 seconds.