Bonjour,
je cherche à créer une nouvelle colonne qui ferait la division réf1 : réf 2 si et seulement si les valeurs d'identification sont identiques.
est-ce que quelqu'un a une solution?
cordialement
And if sorting is not guaranteed, but there are still only one :réf 1 and one :réf 2 for each :Identification, you'll have to do something only a little more complex, like this.
id = :Identification; :réf 1 / :réf 2[Where( :Identification == id & !Is Missing( :réf 2 ) )[1]];
If the format is always as shown in your example picture,
:réf 1 / Lag( :réf 2 );
If the check of :Identification is necessary,
If( Lag( :Identification ) == :Identification, :réf 1 / Lag( :réf 2 ) );
If identification can only appear twice and only one of them has the value filled in, you can use any of col statistical functions such as col min()
Col Min(:ref1, :id) / Col Min(:ref2, :id)
There are also plenty of other options which might slightly depend on the full data you have.
merci pour vos réponses.
voici les résultats avec les 2 formules proposées.
