Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Increment by 1 evey time cell greater than 18k or not blank

oneillp111
9 - Comet

I am trying to add an index or grouping every time a cell is not blank. In the image below I have a multi row formula that adds a month to the Minimum new date value every time the running total exceeds 18k.  Ideally I need to add month everytime so the NextMonth column would be 10-27-2022 at the first 18k and then 11-27-2022 at the second 18k.  I could not figure out how to do that so I thought maybe I could add an index every time NextMonth is not empty.  Anyone have any ideas??

oneillp111_0-1653316309041.png

MultiRow 

oneillp111_1-1653316509328.pngoneillp111_2-1653316530236.png

Included sample data with desired output.  Basically in the output tab, every time the running total is 18k or more, add 1 month to the Minimum date.  So in this data set, the next month would range from 9/27/2022 - 12/27/2022

8 REPLIES 8
binuacs
20 - Arcturus

@oneillp111 Can you provide some sample data and expected output

IraWatt
17 - Castor
17 - Castor

Hey @oneillp111,

Here's one example of how to do this:

IraWatt_0-1653317577230.png

 

binuacs
20 - Arcturus

@oneillp111 Another way of doing this with the formula tool

 

binuacs_0-1653322109803.png

 

oneillp111
9 - Comet

I added a sample set with output tab

oneillp111
9 - Comet

@binuacs thanks for this but this would only chnage the date to 10/27.  I need to increment everything the running total hit 18k.  So it would go all the way to 12/27/2022.

IraWatt
17 - Castor
17 - Castor

Hey @oneillp111 

I've updated my workflow with your example data

IraWatt_0-1653322782196.png

let me know if there are any issues

 

binuacs
20 - Arcturus

@oneillp111 attaching the updated workflow 

 

binuacs_0-1653322965251.png

 

oneillp111
9 - Comet

Solved my issue by adding a Record ID and Tile on Unique values, utilizing the Tile Sequence number as the months to add to Minimum ship date.  

oneillp111_0-1653325822476.png

oneillp111_1-1653325940621.png

 

 

 

Labels