Mar 19, 2013 #1 landview Programmer Mar 19, 2013 4 US My formula is: whileprintingrecords; Numbervar X := x + {@est_hrs_per_task} when I run the report I get the Error as: {@est_hrs_per_task}:<null> var X:0 Exp x:0 I want to get zero when {@est_hrs_per_task} is Null. So how can solve this problem?
My formula is: whileprintingrecords; Numbervar X := x + {@est_hrs_per_task} when I run the report I get the Error as: {@est_hrs_per_task}:<null> var X:0 Exp x:0 I want to get zero when {@est_hrs_per_task} is Null. So how can solve this problem?
Mar 19, 2013 #2 briangriffin Programmer Nov 6, 2008 878 US This would probably be handled better in the {@est_hrs_per_task} formula, but it would look very similar to how you would handle it in this formula: whileprintingrecords; Numbervar X; Numbervar Y; if isnull({@est_hrs_per_task}) then Y := 0 else Y := {@est_hrs_per_task}; X := x + Y; X Upvote 0 Downvote
This would probably be handled better in the {@est_hrs_per_task} formula, but it would look very similar to how you would handle it in this formula: whileprintingrecords; Numbervar X; Numbervar Y; if isnull({@est_hrs_per_task}) then Y := 0 else Y := {@est_hrs_per_task}; X := x + Y; X