Weighted average rate calculation

[5tac3y111]

Hi, 

I'm attempting to analyze the pricing data, which includes the rate at which the price is sold, the recommended target price for selling, and the lowest floor rate allowed for selling it. I'm interested in calculating the weighted average of the sold rate, target rate, and floor rate by product name in Alteryx. Could someone assist me with the workflow for this?

Thank you.

[aatalai]

@5tac3y111 does this help?

[peterr_h]

Alteryx actually has an inbuilt Weighted Average tool! I've attached a workflow for you, let me know if it doesn't help!