In a table I have an "Indicators" field in which I have a Value 'Pause' repeat twice.
For each Name ,I once have the value 'Pause' (in bold in my table) which is always under the value 'Post-travail'.
This value 'Pause' in Bold corresponds to the sum of values which are below.
I am looking to replace this 'Pause' value with the text 'HorsProd'
Name
Indicateurs
Nombre
Temps
Nom1
Attente
5
0h29'19
Nom1
Traitement
5
0h53'03
Nom1
Appel entrant
5
0h53'03
Nom1
Post-travail
5
0h12'23
Nom1
Pause
1
0h01'03
Nom1
Pause
1
0h01'03
Nom2
Attente
18
1h23'36
Nom2
Traitement
20
2h09'32
Nom2
Appel entrant
16
1h51'47
Nom2
Rappel
2
0h17'24
Nom2
Numérotation
2
0h00'21
Nom2
Post-travail
18
0h42'05
Nom2
Pause
3
0h29'21
Nom2
Pause
1
0h00'13
Nom2
Personnelle
2
0h29'08
At first with the help of the community I managed to get there thanks to the Number fields by adding a flag max (number) and a group by where clause
It works if the Number of 'Pause' value is > to the Number of 'Pause' (see Name2 example)
But see Name1 example :
If the value of the Number Pause field is equal to the value of the Number 'Pause' field, it does not work anymore
Also my question is how to change the field INDICATORS to replace the text 'Pause' which is always below the value 'Post-travail' by the value 'HorsProd'?
