I have a sum in a Saved Search for Column A + Colu...
# generale
Edgar Valdés
04/21/2021, 5:57 PMI have a sum in a Saved Search for Column A + Column B. It works OK, except when column A or B is empty, in that case the result is also empty instead of casting the empty value as zero. How can I handle that case?
s
scottvonduhn
04/21/2021, 6:01 PMYou can use either NVL or COALESCE in a formula to force empty values to be treated as zeroes, for example:
NVL({column_a}, 0)COALESCE({column_b}, 0)e
Edgar Valdés
04/21/2021, 6:25 PMPerfect!!!
Edgar Valdés
04/21/2021, 6:26 PMThanks, @scottvonduhn
n
NetCase
04/22/2021, 8:02 AMhow did you sum Col A + Col B?
5 Views