Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone
I have a value replacement problem
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'?
Thank you in advance for your help
Bruno