I am scratching my head like hell...

I have a main report which has a number field linked with a subreport.

//@SubFormula
//Stores the value of the {@TAT_AvTAM} field
//in a number variable called 'myTotal'

WhilePrintingRecords;
Shared NumberVar myTotal := {@TAT_AvTAM}

//@MainFormula
//Returns the value that was stored
//in the shared number variable called
//myTotal in the subreport

WhilePrintingRecords;
Shared NumberVar myTotal;
myTotal

The output is in the main correct, but there are several values in the sub report which do not exist and are present as blanks. This is intentional. I want to take these number fields and use the average function on them.

At present all null values in the sub report are being passed a zeros which will skew the average calculation. Is there any way to force the passing of null values, or is a null number field zero by definition?

Failing that, I tried using a simple IF statement to exclude all values of the passed field which should be null (there are other fields in the main report which would indicated this) but this has not worked either.

Anyone have any ideas?


Edited by skinfreak - 29 Jul 2009 at 6:01am

Unfortunately that did not work - {@TAT_AvTAM} is a number field nad crystal errors that it requires a number. If I sub the myTotal :="" for myTotal :=0 it's fine.