Number variable printing formula help 3

[rinder]

I've created the following conditional running total based upon what I've learned from other postings here......

whileprintingrecords;
numbervar ordrunningtotal;
if ({@OrdNo} <> previous ({@OrdNo}) )
then
ordrunningtotal:=ordrunningtotal + {@OrdTot}
else
ordrunningtotal := ordrunningtotal

the problem is that this formula excludes the very first record from the running total, can anyone help?

Thanks in advance for your help.

N

 

[lbass]

Try:

if not (onfirstrecord) and
{@OrdNo} <> previous ({@OrdNo})
then//etc.

-LB

 

[Naith]

lbass is on the right track, but I think that'll still excluse the first record from the total.

What you're after looks more like:

whileprintingrecords;
numbervar ordrunningtotal;

If OnFirstRecord
Then
ordrunningtotal:=ordrunningtotal + {@OrdTot}
Else
if ({@OrdNo} <> previous ({@OrdNo}) )
then
ordrunningtotal:=ordrunningtotal + {@OrdTot}
else
ordrunningtotal := ordrunningtotal;

Naith

 

[Reebo99]

Why don't you just change the syntax slightly to :

whileprintingrecords;
numbervar ordrunningtotal;
if ({@OrdNo} = previous ({@OrdNo}) )
then
ordrunningtotal := ordrunningtotal
else
ordrunningtotal:=ordrunningtotal + {@OrdTot}

The first value will not meet the criteria, therefore being correct.


Reebo
Scotland (Sunny with a Smile)

 

[Naith]

Even better.

 

[lbass]

Oops. Yes, I should have said:

if onfirstrecord or
(not (onfirstrecord) and
{@OrdNo} <> previous ({@OrdNo}))
then//etc.

-LB

 

[rinder]

Thanks all, lbass' formula worked. I tried Reebo99's but I still had the same problem but I appreciate the assistance non the less.

Regards,

Rinder