Effective in version 10.4.0, Enterprise Data Preparation handles NULL values following Informatica Data Engineering processing behavior. After you upgrade the application, formulas in recipes that operate on worksheet columns containing a NULL value or an error value return NULL.
When you open a project created in a previous release, a dialog opens prompting you to upgrade the worksheets in the project. If you choose to upgrade the worksheets, the application recalculates the formulas in each worksheet in the project, and then updates the worksheet with the new formula results.