Alteryx Designer Desktop Discussions

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

Stop Workflow if Total is Not Met

hellyars
13 - Pulsar

I want to build a safeguard into my workflow that stops it if the sum of the records does not equal X.

 

In the example...

X = 100

The sum of the records is <100, so I want the workflow to error and NOT pass the records to the Transpose Tool unless they sum to 100.

 

hellyars_0-1659542235380.png

 

1 REPLY 1
hellyars
13 - Pulsar

I came up with this temporary solution, where I append a Delta field and then pass it through a Filter set to 0.

But, I don't want to append a Delta value to thousands of records.

 

hellyars_0-1659544457334.png

 

Labels