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
