Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Converting EXCEL formula into Alteryx expression/workflow

BogdanCalacean
7 - Meteor

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!

2 REPLIES 2
Treyson
13 - Pulsar
13 - Pulsar

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'?

 

 

Treyson Marks
Managing Partner
DCG Analytics
BogdanCalacean
7 - Meteor

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"

Labels
Top Solution Authors