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

Calculation Help

moblender
7 - Meteor
WXYZ
1001 66,513.142,229.58
#3,113 92,867.47

 

What I'm looking for is a way to find the values in green where the excel formula is Y/$Z$*$X$ and then to restart at every instance of #. 

7 REPLIES 7
moblender
7 - Meteor

I managed a solution but it's rather ugly and if there's a better way I'd still like to explore :-)

binuacs
21 - Polaris

@moblender what is the calculation for the values 2,229.58 and 92,867.47?

moblender
7 - Meteor

@binuacs The 92,867.47 is just a sum total. 2,229.58 is (66,513.14/92,867.47)*3,113

martinson
11 - Bolide

Do you have a sample dataset to look at?

Cheers,
martinson

LinkedIN

Bulien
moblender
7 - Meteor

Raw Data example

Sale Amount

22,191.78
Sale Amount10,930.34
Expense8,660

 

What I'm after is the allocated expense

 

 Allocated Amount

Sale Amount

22,191.785,802.19
Sale Amount10,903.342,857.81
Expense8,660 
Sum of Sales33,122.12 

 

For each group of sales amounts there is an expense. The expense lines are denoted in my dataset with a #. I want to be able to sum the sales until each # is reached and then, create the allocation amounts based on the expense and total of the sales. Allocated amount is (Sales/Total)*Expense

martinson
11 - Bolide

I'm still not sure how your data looks, however, this is what I have come up with. Please let me know if it helps or if you need anything else.

Cheers,
martinson

LinkedIN

Bulien
moblender
7 - Meteor

Thanks! Pretty similar to what I ended up doing myself though admittedly mine is more....barbaric 🤣

Labels
Top Solution Authors