Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 question is if the field is updated in Salesforce, will that value still be 0? Or will it change to the updated value?
Thanks!
Solved! Go to Solution.
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.
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.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |