How to create a custom field in Empower 3 that replaces blank values with other values, such as 0 - WKB219223
Article number: 219223
OBJECTIVE or GOAL
Create a custom field that replaces the concentration value with 0 if it is blank.
ENVIRONMENT
- Empower 3
PROCEDURE
1. Create a custom field with the following settings:
REPLACE(Amount,0)
2. Perform the processing:
*In the custom field "Replace_Concentration", 0 is displayed when the Concentration value is blank, and the value is displayed when there is a Concentration value.
ADDITIONAL INFORMATION