Issues with subtract empty rows

[gin_nguyen]

Hi all,

I have an issue with subtract empty. Not sure if it is my workflow problem or if i miss anything. So i have:

let say 

Col 1: Monthly Target

Col 2: Month 1 (has value)

Col 3: Month 2 (has value)

Col 4: Month 3 (empty after using summarize since there is no values)

Col 5: Month 4 (empty after using summarize since there is no values)

Subtotal : add up Month 1,2,3,4 after subtracting

when I use Formula node to subtract Row 1- Row 2- Row 3 - Row 4 - Row 5. It ends up only subtracting Row 1 - Row 2- Row 3, leaving month 4 and month 5 empty (I think it is because Month 4 and 5 has o value so the program didn't pick it up) and the subtotal was wrong as it only add up the result from the Month with values

Thank you

[echuong1 · Accepted solution]

Yes, the null values for the latter months is causing the issue. 

Use a data cleansing tool to fill in the nulls with 0's, then re-run. Let me know if that works!