Formulas for zero

[scwk]

hi


need help, i'm new to crystal reports
Can i know what formula to use to put zero on a field?

I done a query in Access and connect this to CReports
and then i'm doing a total but this don't give me the good result, some did when all the fields contains values, but those who do not contain any value, the sum can't be calculated.

what must i do?
many thanks
scwk

 

[2ffat]

I'm not an expert but if I understand your problem correctly, there are two options. One is to turn on "Convert NULL Field Value to Default." This can be found in your options, reporting tab.

The other option is to create a formula and total on that. The formula might look like:

if ISNULL{mytable.numberfield} then
     0
else
     {mytable.numberfield}

Some of the experts here can probably do a better job of explaining this. James P. Cottingham

When a man sits with a pretty girl for an hour, it seems like a minute. But let him sit on a hot stove for a minute and it's longer than any hour. That's relativity.
[tab][tab]Albert Einstein explaining his Theory of Relativity to a group of journalists.

 

[scwk]

thanks James But when using the formula, there is a syntax error message, the keyword 'then' is missing
can you reply me please?
its very urgent i d'ont found any solution

thanks
scwk

 

[ndp]

hi
here try this

if ISNULL({mytable.numberfield}) then
0
else
{mytable.numberfield}


pg