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?
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.
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
User | Count |
---|---|
35 | |
30 | |
30 | |
20 | |
18 |