Update module, formula error

[NickVa1]

Hi Fusion Community,

Fusion is running into an error when trying to update a custom field, based on a formula I've inputted.  See the following screen shot.

It appears that Fusion throws an error when trying to populate a value in this formula field because the formula references a couple fields that are blank. Is there an easy way to account for blank values in those fields so that the formula treats them like zeros instead of blanks?  They are manual-input fields that can have a value or be blank.

This is the error I'm receiving:

Invalid number in parameter 'DE:Last Month’s Revenue to be Recognized'.

Thanks,

Nick

[Jason_JB]

Hi - what would you like Fusion to do if it is null or 0?

Most of the time I add a filter right before the module to filter out results that would error.

Other times I'll use some form of formula to change the value.  Here are a couple examples of formulas I'm using: