Converting EXCEL formula into Alteryx expression/workflow

[BogdanCalacean]

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!

[Treyson]

Hey there,

I just want to make sure I am reading this formula correctly.

1. You are wanting to see how many times each the number on each row has shown up at that point.
2. You are also checking to see how many times the number on each row shows up in total but also the inverse of the number on that record.
3. You want to then compare whichever thing from #2 is lower.
4. If that number is the same as the number in step 1, then 'Storno' else 'Not Storno'?

[BogdanCalacean · Accepted solution]

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"