Forum Discussion
Rsanjuan
9 years agoAdvocate III
Replace null with 0
This may be a very basic question, but I want to add two columns together, and one column has a null value for now. I know I can add them together by replacing all the null values with 0. My questi...
- 9 years ago
Once the Salesforce data is updated, then, upon refresh, the null will be something not null and thus your addition would be that non-null value plus your other, presumably non-null value and thus your first non-null value would be non-zero (assuming your IF logic is correct) and thus the updated value.
Greg_Deckler
9 years agoCommunity Champion
Once the Salesforce data is updated, then, upon refresh, the null will be something not null and thus your addition would be that non-null value plus your other, presumably non-null value and thus your first non-null value would be non-zero (assuming your IF logic is correct) and thus the updated value.