Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Issues with subtract empty rows

gin_nguyen
7 - Meteor

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

1 REPLY 1
echuong1
Alteryx Alumni (Retired)

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!

Labels
Top Solution Authors