Hi there,
I have two tables:
- One that stores a sale
- One that stores interactions
Each sale has a date. Each interaction also has a date. There is a client dimension, each client can have multiple interactions. I can link to the interactions in the table where I see the sales. I'd like to calculate how many days are between the last interaction, and the actual sale. In my test, there are three interactions (note: European date notation):
11/2/2025, 28/11/2024, 6/12/2024
These are shown via a lookup value in my sales table.
The sale is formatted as follows: 11/4/2025 08:10
If I create a formula to calculate the number of days between last interaction and sales date, I get an incorrect answer: 20189
I think this is because the dates are not treated as an array, but as one text string.
Anyone an idea how to solve this? Thanks!