Hello coda community!
I am completely struggling to get my subscription overview working.
The goal is that the i define with checkmarks who is using which service.
The second table calculates the me the cost per slot per service.
Afterwards everything should be sumed in the last column of the first table.
I tried with Lookup and Filter but so far without any good results.
Very grateful for valuable suggestions
Many thanks
Matthias
Hi @anon60586662 
,
I’m not sure to understand the “per slot per service” but, is this what you were trying to do ? (or similar 
)
Instead of using checkboxes I added a Lookup fields (from the table Subscription Prices to Subscription Overview) and then selected for each person the services they are subscribed to …
To calculate the sum of those subscriptions, I just added this formula into the Cost field
thisRow.[Subscription Prices].Monthly.Sum()
And what it does is, it takes the list of services in the lookup fields, retrieve the corresponding Monthly cost from the table Subscription Prices for each listed services in a row and simply Sum() them
Let me know if this helps (or if I’m completely wrong and it was not what you were after 
) … or if you need me to add more info about what’s going on !
Hah, @Pch , you beat me to it. 
My interpretation was summing, for each user, the price per slot rather than the price per subscription.
I’m actually really not sure if I interpreted the demand correctly … I just took a leap of faith … !
So, you might be right here 
We can’t see you embed …
Doh 
Have set to ‘anyone with the link can view’. Hopefully working now?
It works perfectly 
!
Thanks guys for your input!! Yes Tim you are right, i need an overview what each user has to pay me.
You nailed it 
Really like this view.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.