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:
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:
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