Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Dividing an input number based on months available

shravanvijayaprasad
8 - Asteroid

I'm a little confused on how to achieve this. It would be great if someone can help me with this. I have a table

MonthName
1sss
1tt
1uu
1vv
1ww
2ss
2tt
2uu
2vv

 

I want to get an input from user (a number say 100) and based on the number of months available (here 2), I want to split it up for the two months. The complexity comes because I just want to populate the first row of each month with the divided value (50) Example output is below

MonthNameValue
1sss50
1tt 
1uu 
1vv 
1ww 
2ss50
2tt 
2uu 
2vv 
1 REPLY 1
fmvizcaino
17 - Castor
17 - Castor

Hi @shravanvijayaprasad ,

 

Attached is an example showing how to do it.

fmvizcaino_0-1583809026710.png

 

 

Let me know if this works for you.

Best,

Fernando Vizcaino

Labels
Top Solution Authors