Forum

Notifications
Clear all

Distributing revenue in dataset where the average & Total Sum are known

2 Posts
2 Users
0 Reactions
194 Views
(@jcunney)
Posts: 1
New Member
Topic starter
 

Hi There,

I was hoping someone could assist with creating a sample data set based on a couple factors as I can't seem to figure it out 🙁

I have a fake company yearly revenue of $3,500,000 split between 117 customers where the average contract is $30,000.

What I'm trying to accomplish is random $ values for all these customers eg.

Customer 1 : $100,000

Customer 2 : $60,000

Customer 3 : $20,000

Total: $180,000

 

I wasn't able to find anything that seemed like the solution to this anywhere so Thanks for any help anyone can provide!

 
Posted : 24/05/2022 11:46 am
(@sunnykow)
Posts: 1417
Noble Member
 

Hi Josh

Give this a try. It randomly distribute a fixed value across a range.

Hope this is what you are looking for.

Sunny

 
Posted : 25/05/2022 5:45 am
Share: