Ranking and Ranking sort

Good day, I am having an issue with my conditional statement. The workflow runs fine but for some reason the ranking conditional statement is not ranking the files correctly. It will rank the the Red Risk Levels correctly but everything else falls into the Null section of the conditional statement. Is there something wrong with my statement or am I missing an additional tool? Any help would be appreciated

BAL Leasing Renewal.yxmd

Best Practices

Accepted answers

MichaelLaRose

Hi @douglaskrohn ,

I was able to get the formula to work the way it looks like you intended, but there seems like there is room for gaps.

For example: If you have a Tenant Lease SF over 2500 but it is between 120 and 180 days you don't fall into any category.

Note: I changed the file address so that it looks for the .xlsx in the same folder as the Alteryx workflow so if you just put the two files in the same place they will run.