I'm trying to calculate a very simple sum of values stored in several
Number columns, so i've created and Formula column. The result is
properly calculated when all the Number columns have a value, but if
any of them is empy then I get '*****' as result.
Formula = Number1 + Number2
10 + 12 = 22 (ok)
10 + (blank) = ***** (not ok for me)
10 + 0 = 10 (ok, but i don't want to fill all the blank fields with
Is this a normal behaviour? Is there any workaround to get the total
sum working fine with blank fields?
Thanks in advance and we keep in touch!