Hello! I have a workflow where I have 2 different Tile Tools. For the 1st tile, I have the Age Group (Tile #1 is N/A, Tile #2 is Under 35, Tile #3 is 35-44, Tile #4 is 45-64, Tile #5 is 65-74, Tile #6 is 75+ and Tile #7 is N/A. For anybody with an age under 20 or over 100 should be grouped into N/A, so I'm not fully sure if I did that correctly.
For the 2nd Tile, I have the AUM Group (Tile_Num 1 is Under $10k, Tile_Num 2 is $10k-$10M, Tile_Num 3 is $10M-$50M, Tile_Num 4 is $50M-$100M and Tile_Num 5 is over $100M).
The AUM tile should align with the AUM group column, but when looking at the output, that doesn't seem to be the case and I'm not 100% sure how to get the AUM tile to align with the AUM group column. Attached I have the workflow, screenshots of both Text Input tools and Tile tools, along with a snippet of the output. Can someone please take a look and provide suggestions on how I can correct this? I would greatly appreciate it!
Why don't you give a try to formula tool that will be easy way to deal with this.
you can share the sample data so we can help with the formula as well if needed.