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

Formula based on a row

bethgrap
7 - Meteor

bethgrap_0-1587658369756.png

Is there a formula I could use to say: If Total CSG Sales for Programming does not equal Per P&L sales for Programming, allocate the total Per P&L sales to each state to equal Per P&L sales?

 

Thanks!

3 REPLIES 3
RolandSchubert
16 - Nebula
16 - Nebula

Hi @bethgrap ,

 

in my understanding, "Total CSG Sales" is the total of the states values above, right? I would split off the two total rows (text length > 2 could be used to select), calculate the relation between the values and multiply this relation with the state sales figures. I've attached a sample workflow. What do you think?

 

Best,

 

Roland

bethgrap
7 - Meteor

That works!

 

But now, how would you get the Total & P&L columns back to rows?

 

Thanks!

RolandSchubert
16 - Nebula
16 - Nebula

I added the "re-union" part to the workflow, in addition to the allocated sales values, the "total" rows are at the bottom of the table. Hope this is helpful.

Labels
Top Solution Authors