Update module, formula error | Community
Skip to main content
N
NickVa7
New Member
December 19, 2022
Question

Update module, formula error

  • December 19, 2022
  • 1 reply
  • 525 views

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

 

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

Jason_JB
Jason_JB
December 21, 2022

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:

 

 

 

Terms & ConditionsAccessibility statement

Loading footer...