Hello there. I stucked with some interesting behavior. Shortly:
- There are two tables that linked (project and tasks). In the tasks I have “responsible” and “rating” fields. All tasks have link to their parent project.
- In the parent project I can see a “rating” field, that calculates the sum for all tasks linked to particular project for certain "responsive person. For that I use formula like:
sum(filter(lookup(‘tasks’, ‘rating’),lookup(‘tasks’,‘Responsible’) = ‘Smith’)).
Everything worked fine until last week. Now this formula gives me sum for all tasks linked to this particular project. - If I dropped sum key from formula, like - filter(lookup(‘tasks’, ‘rating’),lookup(‘tasks’,‘Responsible’) = ‘Smith’), I’ll see right numbers.
It looks like fresh bug…
But maybe I doing things wrong?