For test calculation I use 3 rows, rows contain Row owner (on email).
The task is to calculate how many clients the user brought in and how much money they earned for the application (referral program).
The rows are linked to other tables. The data is pulled in via the relationship fields:
- rollup, count, sheet “clients”, link through the field “partner code”; the sheet contains the row owner on the field email
- rollup, sum, sheet “purchasing”, link via the field “partner code”; the sheet contains the row owner on the field email
At the same time, the row owner on both sheets was not the partner (for whom the calculation is done), but the client. Therefore the partner should have initially received zeros in the result.
After the calculation fields were created, they were filled in with the correct calculation data. When the page was published, zeros started appearing on the page. At the same time the data in the table are correct (see screenshots). Refreshed the page with the table, including via cache reset - nothing has changed.
It seems to be a situation, when in one place the calculation has already passed (output of values on the page), but in another place it has not (output of values in the table).
After some time in the table first the values for one partner are correct (zeros), after 10 minutes the values for the second partner are correct.