Printable View
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
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
Quote:
Originally Posted by jggtz
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.
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?
is to account for the lack of formula. the amount of foul.
Quote:
Originally Posted by Fabiano2016
is to account for the lack of formula. the amount of foul.
Quote:
Originally Posted by Fabiano2016
Can anyone help me.