Count filter / virtual column

[Renaud1]

Hello,

I have two tables

-First parent table “BDD BONS ENLEVEMENT”

-Second children’s table “BDD DETAIL BONS ENLEVEMENT”

I want to count the number of rows present in the child table with the following formula:

COUNT (
FILTER (
“BDD DETAIL GOOD REMOVAL”,
([PRODUCT NUMBER CORRECT COLLECTION] = [_ THISROW]. [PRODUCT NUMBER CORRECT COLLECTION])
)
)

In the parent table, it works when I insert the formula in a virtual column, but it doesn’t work when I insert it in a table column.

Does anyone know why?