If date exists twice, then do this

[Mahran]

Hello, I have the following problem:

I have a table with several columns. One column is a date field and the other column contains numbers with 1 and 2. These numbers come directly from the database.
I would like, if there is a date twice (e.g. here 13.11.2023), then there should be a 3 in the other column.
How can I achieve this?

[vincent_ardiet_ · Accepted solution]

Do you want 3 because this is the cumulated value?
Do you have access to the script or this is something to do in the UI?

[Mahran]

I have found a solution. I calculated a sum from the values and said that if the sum for both numbers is greater than 0, he should write the value there.

Thanks for the answer.