Missing input data

[yzanferr]

Hello,

I have a sheet with data, but within the same column depending on the day, the values could change.

Example.

day 1 - column A has 1, 2,3 and 4

the formula is:  if  1-2 or 3-4

day 2 - column A has 1, 2, 3  but no 4

the formula is:  if  1-2 or 3-4 - Now I get an error on Alteryx from trying to use "4" but not having it.

Is there a way to use it as a Sumif? For Alteryx to ignore if the data is not coming?

Thanks,

Yuri

[FredNajjar · Accepted solution]

Hi @yzanferr, 

an equivalent of sumif wouldn't really solve your problem. Bascially, if the field (column 4) is not present in your data source/input then there is nothing to calculate. 

The way I see around your issue is to make sure all columns are present when running the workflow, here is an example 

PS: if you found my solution useful, please mark this question as resolved. 

Cheers, 

FN 

[yzanferr]

Thanks, Fred. It is an elegant solution.