summing up blank column using formula tool

[Pushkar]

Hi all,

I have 4 columns and few column are blank. When I try to add the column using formula tool it shows null if any one column is null. 

The row 2 should show sum as 6

The row 3 should show sum as 3...

Can someone help me to resolve it.

[Jonathan-Sherman · Accepted solution]

Hi @Pushkar,

I would use the data cleansing tool to replace nulls with 0 and then use the formula tool from there to create your total column.

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan

[Pushkar]

@Jonathan-Sherman

Thanks for your help.

I was looking for solution where I don't want replace the null values to Zero.

Is it possible with that or can we again replace the zero which is coming out in your solution again to null/blank.

[Jonathan-Sherman · Accepted solution]

Hi @Pushkar,

You could use a formula to convert nulls to zeros when creating the total column:

IF IsNull([Field1]) THEN 0 ELSE [Field1] ENDIF
+ IF IsNull([Field2]) THEN 0 ELSE [Field2] ENDIF
+ IF IsNull([Field3]) THEN 0 ELSE [Field3] ENDIF
+ IF IsNull([Field4]) THEN 0 ELSE [Field4] ENDIF

[JulesFontaine]

I was having the same issue and this fixed it. Thank you!!