Need help in formula tool.

[anonymous008_G]

Hi there – I have a task of automating one of our monthly report. I am facing some challenges in the attached sample workflow where the source data sometimes has short bucket, sometimes long bucket and sometimes both. I have developed the first workflow, which works as expected when there is only a short bucket in the workflow. How do I write formula which would work in any cases either there is short bucket or long bucket or both the buckets available in the source data.

I have provided both the workflows (Failed and pass ) in the attachment. Please help me in this. 

Thank you in advance

[binuacs]

@anonymous008_G There is no field called Short in your second workflow, remove the short formula and it should work

[anonymous008_G]

@binuacs - thank for your response. Unfortunately, this would not work. Suppose if any month only long bucket comes in the source data then your formula for long will work but suppose in any month Long doesn't come and only Short bucket comes, then it will fail vise versa for short. So i need some solution that will work if in any below 3 scenario. 

1. Only Long bucket available (No Short data)

2. Only Short bucket available (No Long data)

3. Both Buckets available. 

Can we do that in alteryx? Please let me know if you need more detailed workflow to understand the requirement.

[binuacs · Accepted solution]

@anonymous008_G 

[anonymous008_G]

Thank you