Help with a Computed column

[Ninan_Joseph]

I would like to have help on the following issue with computation in tables:

1. I have three column fields namely, Apt_No, Name, and Water charges.
2. Since there are two people staying in the same apartment, I have used two rows with the same apartment number (Apt_No) against which Names of the residents are entered.
   Eg:
   Apt_No Name Water*
   1 Jack 30
   1 Jane
   2 Joe 30
   2 Mary
   • I need a computed column here where 30 must appear only once if the Apt_No is the same.
   Could someone help, please!

[micheal]

are you using a relation for this ?
I’m sure each user has a user profile (or not). For each user, assign an apartment number for them, and then you can easily make a relation that writes to both in the same apartment.

So instead of writing two rows for each user, it would be a single row

[Ninan_Joseph]

Thank you Michael for the quick response.
I have created relations with Apt_No. All that is fine. Here the User is the Apt-No itself. My issue is that IF the Apt_No is the same there should only be one value in the last column titled Water

Ninan Joseph

[Darren_Murphy]

• Add a RowID column to your table
• Create a multiple relation column that matches the apartment number with itself
• Use a Single Value column to fetch the first RowID via the relation
• Finally, add an if-then-else column:
  – If RowID is Single Value RowID, then Water

The result of the above is that the if-then-else column should contain the value of the water column in only the first row occurrence of each apartment number.

[Ninan_Joseph]

Wow Darren! That was superb! I got it! Thanks a Million!!