Need help in formula tool.

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

Sample flow.yxmd

Help

Accepted answers

binu_acs

@anonymous008_G

Sample flow (1).yxmd

All comments

binu_acs

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

anonymous008_G

@binu_acs - 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.

Thank you

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335