Help

Cost calculation

Topic Labels: Base design
Solved
Jump to Solution
164 2
cancel
Showing results for 
Search instead for 
Did you mean: 
pheck1964
4 - Data Explorer
4 - Data Explorer

Hello! As I'm quite new on Airtable, I need some help on the general approach for the following task:

I already have a table of products for my Webdesign Agency with prices per year and use this also to track by renewals.

Structure like in this photo:

pheck1964_0-1732186940628.png

Now, I want to have a table, where I can distribute the costs to my customer. I would need to assign products to customers and based on the numbers of customer assigned to a product, the cost per customer is calculated (Price of the product divided by the numbers of customers using this product = price per customer) and it should be displayed like in this Excel table I use currently:

pheck1964_1-1732187333377.png

Honestly saying, I have no idea, if such a scenario could be done with Airtable or if I should use Excel instead...

So my question: Is this possible and if yes, is there any tutorial available, where such a scenario is explained?

Thanks in advance for your help!

Cheers Peter



1 Solution

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

Hmm, getting it displayed like that would be quite difficult; if you could talk a bit about your business case perhaps we could find a workaround?  Getting the split per company and the total per customer is fairly easy though, here's a simplified example:

Screenshot 2024-11-21 at 9.19.05 PM.png

Screenshot 2024-11-21 at 9.19.03 PM.png

  



Link to base

See Solution in Thread

2 Replies 2
TheTimeSavingCo
18 - Pluto
18 - Pluto

Hmm, getting it displayed like that would be quite difficult; if you could talk a bit about your business case perhaps we could find a workaround?  Getting the split per company and the total per customer is fairly easy though, here's a simplified example:

Screenshot 2024-11-21 at 9.19.05 PM.png

Screenshot 2024-11-21 at 9.19.03 PM.png

  



Link to base

pheck1964
4 - Data Explorer
4 - Data Explorer

Thanks - it brings me a big step forward!