We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Workflow Possible Formula Question

Cferrer6
8 - Asteroid

Hi, 

 

I am not sure if this is possible but wanted to ask... i was trying to look for a countif formula for attached but doesnt appear that there is one. I am trying to have Alteryx review attached data and count the number of "deployment fees" and "Clover Flex" and compare the totals. If the total of deployment fees is greater than the total of Clover Flex then zero the merchant price of the deployment fee. 

 

Any help is greatly appreciated

10 REPLIES 10
Cferrer6
8 - Asteroid

@binay2448 

 

Now to make it a bit more complicated, are you aware of how to do it if there are multiple orders like attached? Same rules just need each order isolated and apply the rules only on a order level. 

 

 

Labels
Top Solution Authors