Problem with Testing for Null

[BradCustom]

Below is a formula I'm woring with in Crystal XI. the value is passed from the subreport to the main report. Unfortunately the test for Null values doesn't work because I keep getting an error saying "there needs to be a field here" on the sum function.

whileprintingrecords;
shared numbervar Allocated := if isnull
(Sum ({SO_Detail.Order_Qty}, {SO_Detail.Material})-Sum ({SO_Detail.Shipped_Qty}, {SO_Detail.Material})
)
then 0
else 
(Sum ({SO_Detail.Order_Qty}, {SO_Detail.Material})-Sum ({SO_Detail.Shipped_Qty}, {SO_Detail.Material}))

Thanks for help on this formula!!

 

[CoSpringsGuy]

I would suggest changing your formula to use default values for null instead of testing for null values. The reason I would take that approach is because I assume order and shipped quantity could both be null. The sum function wont work if either comes back as a null. Changin ght edefault to null will return 0 instead of null.

_____________________________________
Crystal Reports XI Developer Version
Intersystems Cache 5.X ODBC connection

 

[lbass]

Try setting up a formula {@Allocated}:

Sum ({SO_Detail.Order_Qty}, {SO_Detail.Material})-Sum ({SO_Detail.Shipped_Qty}, {SO_Detail.Material})

Then change your formula to:

whileprintingrecords;
shared numbervar Allocated := if isnull({@Allocated}) then
Allocated := 0 else
Allocated := {@Allocated};

-LB

 

[BradCustom]

Thanks LB that works perfectly. I actually had a formula called {@Allocated} so I just needed to change the pass formula.

Thanks angain for your help!!