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?

[Aurelien]

Hi @Renaud

This is because virtual columns are calculated on the fly, so results are always correct, provided calculation reaches its end.
Real/physical columns are calculated only on editing.

In your case, I suspect this is what happens.

[Renaud1]

Hello,

Thank you Aurélien for your return and happy New Year everyone!
In the column [PRODUIT NOMBRE REMPLACEMENT] which is in my parent table « BDD AFFAIRES », I want to count the number of rows fulfilling the conditions in my child table « BDD AFFAIRES DETAIL ».

Elements :

-Parent table: « BDD AFFAIRES », key column [CODE AFFAIRE]

-Children’s table: « BDD AFFAIRES DETAIL » key column [CODE AFFAIRE DETAIL]

In the « BDD AFFAIRES DETAIL » I have to count the lines
CODE AFFAIRE = CODE AFFAIRE of « BDD AFFAIRES DETAIL »
[PRODUIT TYPE INSTALLATION] = « REMPLACEMENT »

I go through a virtual column to do the counting with the formula below and it works very well

COUNT(
FILTER(
“BDD AFFAIRES DETAIL”,
AND(
ISNOTBLANK([PRODUIT TYPE INSTALLATION])
([PRODUIT TYPE INSTALLATION]=“REMPLACEMENT”),
([CODE AFFAIRE]=[_THISROW].[CODE AFFAIRE]))
)
)

My issue is the following,
I cannot retrieve the result of the virtual column [COLONNE VIRTUELLE PRODUIT NOMBRE DE REMPLACEMENT] to insert it into my table in the column « PRODUIT NOMBRE DE REMPLACEMENT »
Can anyone help me?
It would be so much easier if we could put the formula in the table rather than in a virtual column!
Cordially
Renaud