In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

Formulas

Cspen
7 - Meteor

What formula do I need in order to find the totals for each variable set. This example was pulled from an old workflow and I am trying to replicate it. Thanks in Advance

Screenshot 2024-10-24 161341.png

9 REPLIES 9
Qiu
21 - Polaris
21 - Polaris

@Cspen 
Can you provide more details?

Raj
16 - Nebula

@Cspen 
please add some sample input and expected output
will be in better place to help.

Cspen
7 - Meteor

Here is a very simple example. I have a large data set so my calculations won't be just one but for an example I am looking at the "initial HRA" and "current HRA" to try and calculate how many went  from Low-High, Low-Medium, Low-Low. Medium-High, Medium-Low, Medium-Medium Etc. So looking at the initial HRA if its low and then changed to high in the Current HRA. That is what I am trying to calculate.

Screenshot 2024-10-24 161341.png

Cspen
7 - Meteor

@Raj   The example is above 

@Qiu 

binuacs
21 - Polaris

@Cspen can you also upload the example excel files?

Raj
16 - Nebula

@Cspen 
input files are missing.

Cspen
7 - Meteor

@binuacs @Raj  Here are the sample input files

binuacs
21 - Polaris

@Cspen like this?

image.png

Cspen
7 - Meteor

@binuacs  YES!! Thank you. I was able to figure it out using the IF THEN formula but this is way easier!

 

Thank you!

Labels
Top Solution Authors