
August 29th, 2013, 11:44 AM
#1
Problem to calculate formula
Hello
Good afternoon.
I'm having problems with formulas in crystal'm new to the program, I have to create a formula that has to sum the values.
I created a formula to sum.
1
1
3
1
1
1
2
3
1
2
total = 16
more is not the correct value for the report is that the sum certain.
1
1
3
1
1
1
2
3
1
2
total = 10
it not only sums the values that two or more.
version of Crystal Reports XI

August 29th, 2013, 02:09 PM
#2
Re: Problem to calculate formula
It seems to me that you are using "Count" instead of "Sum"
Are you using RunningTotal field or a Formula field?
If it is a formula then post the code and say in which section you placed it
JG
... If your problem is fixed don't forget to mark your threads as resolved using the Thread Tools menu ...

August 30th, 2013, 07:59 AM
#3
Re: Problem to calculate formula
Originally Posted by jggtz
It seems to me that you are using "Count" instead of "Sum"
Are you using RunningTotal field or a Formula field?
If it is a formula then post the code and say in which section you placed it
Hello
good day
I'm using a field forluma, section I put in Group footer # 3.
I made two formulas to find the value;
1st
Numbervar i;
i: = Sum (AGR_FALTA_ATESTADOS_V.FALTAS {}, {} AGR_FALTA_ATESTADOS_V.CD_FUNC);
2nd
numberVar i: = 0;
if (AGR_FALTA_ATESTADOS_V.FALTAS {})> 0
then i: = i +1
The second that I'm using.

August 30th, 2013, 09:22 AM
#4
Re: Problem to calculate formula
In first formula you are storing the Sum of field FALTAS in variable i
In second formula you are initializing the variable i and then storing the Count of field FALTAS
It's not clear enough
What are you trying to achieve?
Count each time there are FALTAS or SUM the FALTAS?
JG
... If your problem is fixed don't forget to mark your threads as resolved using the Thread Tools menu ...

August 30th, 2013, 10:29 AM
#5
Re: Problem to calculate formula
is to account for the lack of formula. the amount of foul.

August 30th, 2013, 10:33 AM
#6
Re: Problem to calculate formula
Originally Posted by Fabiano2016
is to account for the lack of formula. the amount of foul.
is to account for the lack of formula. the amount of foul.

September 3rd, 2013, 06:58 AM
#7
Re: Problem to calculate formula
Originally Posted by Fabiano2016
is to account for the lack of formula. the amount of foul.
Can anyone help me.
Posting Permissions
 You may not post new threads
 You may not post replies
 You may not post attachments
 You may not edit your posts

Forum Rules

Click Here to Expand Forum to Full Width
OnDemand Webinars (sponsored)
