Create Group with Total field

[Piedad]

I have this data in table:____Serie--Movim----Segu_date-------Salario2--------Mes-----(1)-----(2)__ 464---N-------3/1/2003--------81.88-----------3--------1-------1__ 464---M-------3/1/2003--------80.83-----------3--------1-------1__ 464---F-------3/1/2003--------0.00------------3--------1-------1____ 464---N-------4/1/2003--------80.83-----------4--------1-------3__ 464---M-------4/5/2003--------500.00----------4--------2-------3__ 464---F-------4/10/2003--------0.00-----------4--------2-------3__ 464---F-------4/12/2003--------0.00-----------4--------2-------3__ 464---I-------4/13/2003--------0.00-----------4--------2-------3__ 464---F-------4/13/2003--------0.00-----------4--------2-------3__ 464---M-------4/15/2003--------300.00---------4--------3-------3__ 464---I-------4/18/2003--------0.00-----------4--------3-------3__ 464---F-------4/20/2003--------0.00-----------4--------3-------3____ 464---N-------5/1/2003---------80.83----------5--------1-------1__ 464---F-------5/17/2003--------0.00-----------5--------1-------1____ __(1)_Total field: Count(Movin,Mes(),Every,Running,Conditional)__Condition: iif(Movin=_N_ OR Movin = _M_,1,0)__(2)_Total field: Count(Movin,Mes(),Every,Pre-processed,Conditional)__Condition: iif(Movin=_N_ OR Movin = _M_,1,0)_______I need to create a group line using (1) but that field is running mode and I can_t,if i change it to pre-precessed mode i get (2) and it isn^t i need, could you help me please?__:o

[kfleming]

You could create a calculated field with the expression:__Movin=_N_ OR Movin = _M_____And then create a total that is a SUM of this calculation.__When you sum a logical field, a true value returns a 1 and a false returns a 0. So your total becomes a count of the number of trues.____Kathleen__R&R Support

[Piedad]

could you tell me what specifiations are for the total field?__because if i make these:__Calculated field suggested: example= Movin = "N" OR Movin= "M"__Total field suggested: sum(example(),Mes(), Every, Pre-processed)____i got the same data in (2) and i need create a group according with the data in (1);____in fact, for example where Mes=4 i want to create a groupe line for (1)=1 ; other group line for (1)=2 and other group line for (1)=3____i got the data in total field (1) when i select processing: Running, but it dosen^t allow me create sort or groups,____when change it to process: Pre-processed it allow me create sort or groups but the data is like (2) and no groups are there____maybe the question is: it is correct that all of kind of accumulations (options in accumulation box) with pre-processed total field show the same result?________

[kfleming]

You could have a blank line appear (rather than a real group field) __by creating a blank group line below the total and using a calculated field with expression:__TOTFIELD<>PREV(TOTFIELD)__to control printing of this blank line.____Kathleen__R&R Support