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
Accepted Solutions
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 )
);
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]];
Bonjour,
merci pour vos réponses.
voici les résultats avec les 2 formules proposées.
cordialement
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.