Fomula ignores fist line 1

[rewob65]

I am using this formula to obtain the total of a number of fields:-


WhilePrintingRecords;
NumberVar Prior;
NumberVar LYS;

if {@Count} >0 //which indicates a first record for this customer
then LYS := {@Soiled Day 2} + Prior;
Prior := LYS//store the current count to compare with next record LYS

It works fine except for the first record, I guess this must mean that my record is calulated before the @count function. Any ideas to add in the first record.

 

[MisterMo]

I am not sure this will work

you could declare the varable before you start the loop

e.g.

NumberVar Prior := 1;
NumberVar LYS;


WhilePrintingRecords;
if {@Count} >0 //which indicates a first record for this customer
   then LYS := {@Soiled Day 2} + Prior;
Prior := LYS//store the current count to compare with next  record LYS

Mo

 

[Madawc]

Try doing the same thing using running totals. Much quicker once you get the hang of them.

Right-click on a field and choose Insert to get a choice of Running Total or Summary. Or else use the Field Explorer, the icon that is a grid-like box, to add running totals.

Madawc Williams (East Anglia, UK)
Windows XP & Crystal 10

 

[lbass]

You could try:

WhilePrintingRecords;
NumberVar Prior;
NumberVar LYS;

if onfirstrecord or
{@Count} >0 //which indicates a first record for this customer
then LYS := {@Soiled Day 2} + Prior;
Prior := LYS//store the current count to compare with next record LYS

If none of the above solutions work, please provide the contents of both of your nested formulas (which you should always do when posting).

-LB

 

[rewob65]

Ibass your formula did work. I realise why you want to see the nested formula, it is also a calucaltion of a calculation so I thought it would noly confuse, since what I think is a complex question is seen as easy be most adivsers