Hi,
Read a lot of posts here on the community but not got to a solution for my issue.
Can you help convert the following EXCEL formula into Alteryx Expression?
=IF(COUNTIF($A$2:A3,A3)<=MIN(COUNTIF($A:$A,A3),COUNTIF($A:$A,-A3)),"Storno","Not Storno")
Thank you!
Solved! Go to Solution.
Hey there,
I just want to make sure I am reading this formula correctly.
Hi,
That is exactly right. The idea is to identify and eliminate numbers that
are the same but with negative and positive signs. If there are 2 values
of +100 and 2 values of -100 all 4 need to be called "Storno".
Moreover, if there are 3 values: -100, +100, +100, only one positive +100
should be called "Not storno" and the other 2 values should be
called "Storno"
User | Count |
---|---|
19 | |
15 | |
13 | |
9 | |
8 |