Mar 26, 2024 08:41 AM - edited Mar 28, 2024 02:22 PM
I'm a bit stuck. 😅
The end goal is that I can determine how much everyone should be paying in a house depending on the conditions of the room, the minimum price of payment, and the number of people within a room.
--
Information:
----
Example:
An example of how one of the results should be:
Room: Apartment is rank 1. So the percentage that it should look at is: 25.03%, which is 7.258,70. The room is for 2 people so: 7.258,70/2= 3.629,35. Plus the minimum 3.629,35+3.000 = 6.629,35. So per person in the room Apartment a person should pay: 6.629,35.
How do I get this to work? 😅
Apr 01, 2024 02:39 AM
Hello. your tables have a design issue and then the formula will be much easy.
you need to have a key between them all, which is not the case, since in the % you have them as 1A, while in the others it is 1
also, in Room, you have the value per person already at 8K, while in the example you said 7K
unify the primary keys (in this example i am assuming 1 and not 1A, and you can add the % and room in the same table based on what you're explaining - also having a better naming of the fields can help you
then, to solve your problem, bring the relevant fields into the main table (with linked records)
then the formula goes: