I can't get a formula to return a zero 1

[travelerII]

I am using Crystal 10 and am looking for PO quantities by month. I am using the following formula
IF Month ({PORDERQ.EXTRCPDAT_0})= Month (CurrentDate)
then
{PORDERQ.QTYSTU_0}
else 0
in the details section that is suppressed.
I then sum the total and put it in the group footer.
My other formulas return zeros such as for manufactured orders
IF {ORDERS.VCRNUM_0} startswith "MFG" AND Month ({ORDERS.ENDDAT_0})= Month (CurrentDate)
then
{ORDERS.RMNEXTQTY_0}
else
0
I have tried looking at all the formatting options but can't figure out what I have done wrong.
Any help is greatly appreciated.

 

[lbass]

One of the two fields must be null. Try:

If (
isnull({PORDERQ.EXTRCPDAT_0}) or
isnull({PORDERQ.QTYSTU_0})
) then
0 else
if Month ({PORDERQ.EXTRCPDAT_0})= Month (CurrentDate) then
{PORDERQ.QTYSTU_0} else
0

-LB

 

[travelerII]

That did the trick. Thank you.