Caspiosa
-
Posts
2 -
Joined
-
Last visited
Caspiosa's Achievements
-
Tubby reacted to an answer to a question:
Calculate SUM of fields when some of the fields can be NULL
-
Calculate SUM of fields when some of the fields can be NULL
Caspiosa replied to Caspiosa's question in General Questions
Thank you so much! It works like magic! -
Calculate SUM of fields when some of the fields can be NULL
Caspiosa posted a question in General Questions
HI! I want to calculate a sum of several (6) fields using calculated value field. Almost always there will be fields with NULL value among these 6. How do I create a formula that 1) scan all 6 fields, 2) select only fields with value (or replace NULL value with 0) and 3) sum these fields. Thanks!
