Model Builder - Calculate Field "no value" question

[Anonymous User]

Original User: SStrand

During a process I have setup, I have a window pop up that asks me if I would like to continue, due to a calculate field tool having a "no value" for a row. Is there anyway to set up the model so it automatically chooses "yes" for this? I have looked in properties and can't seem to find a way around it.

[Anonymous User]

Original User: dkwiens

You can always build that into the Calculate Field code block. It would depend on your data, but:

Code block:
if [thefield] <> null then
  do some stuff
  result = some calculated value
else
  result = null
end if

Expression:
result