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

transformation and formula challenge

pangersandmash
8 - Asteroid

Hello

 

I am stuck on a problem- wondering if anyone can help please.

 

I basically want to write a rule that says 'when an invoice has FTA, PUBINS, and PCCR, allocate the full amount to PUBINS'.

 

But, only for these 3. The screenshot below should help.

pangersandmash_0-1638887565574.png

 

I tried to use a cross tab tool so i have something like the below

pangersandmash_1-1638887730973.png

 

but i couldn't get any further. Any advice?

 

Thanks

10 REPLIES 10
TheOC
16 - Nebula
16 - Nebula

hey @pangersandmash 

Glad i could help!

Cheers,
TheOC

Cheers,
TheOC
Connect with me:
LinkedIn Bulien
Labels
Top Solution Authors