Simple Sum of float columns with null values - but using less complex formula?

jerome

New member
Hi
Is it normal that in order to process a simple sum of float type columns that contains sometimes null values,I am forced to use such a complex formula (see below in yellow)? Or am I doing something wrong here?
Not using the IsNull formula, or even just not using the parentheses in my formula, lead to a wrongly calculated sum column….
Many thanks for your help.
2022-06-20_132127.jpg
 

Support

Administrator
Staff member
You can use a simpler expression: see the example in the attachment.
 

Attachments

  • example_sum_on_row.anatella
    1.6 KB · Views: 215
Top