Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
We’re experiencing technical issues with our vendor that are affecting license activations for Designer Desktop. We don’t yet have an estimated resolution time. We apologize for the inconvenience and will share updates as we have them.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Creating a Pro Rata Calculated Field

ll98
9 - Comet

Good morning Alteryx community ...

 

I have a dilemma where I'm trying to get a pro-rata rate based on Investor Type -- Once I get that rate -- I'll take that pro-rata rate and multiply by holdings to get a pro-rata holdings per Holdings.

 

Example:

JF1 Holdings

Cost  5000+ 1500 =  6500     

5000 / 6500 = .77

 

Commitments are   8500

 

Pro Rata Amount :   .77  * 8500  = 6438.46

 

 

ll98_0-1615745062433.png

1. I need to get a total cost

2. Calculate the pro-rata based on Type

3. Take Rate and multiple by commitment

 

 

 

1 REPLY 1
Luke_C
17 - Castor
17 - Castor

Hi @ll98 

 

Would something like this work?

 

Luke_C_0-1615747930427.png

 

 

 

Labels
Top Solution Authors