Alteryx Designer Desktop Discussions

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

sum (if..

AlanoudF
7 - Meteor

 

How to get this output in Alteryx ?

Screenshot 2024-08-25 204314.png

5 REPLIES 5
CoG
14 - Magnetar

Please provide more detail to describe the precise behavior you hope to replicate. An image with a massive Excel formula is not very clear.

Qiu
21 - Polaris
21 - Polaris

@CoG 
You are a nice person. 😁

AlanoudF
7 - Meteor

sheet 3 column y is start date 

sheet 3 column z is end date

sheet 1 column B is is manually dates (end Quarter dates )

 

how to do the same formula in alteryx, especially that I want to sum if (cumulative)  conditioning on column B manually long dates list (end Quarter dates )

CoG
14 - Magnetar

That's a start but please describe your formula. You know what it does, but we don't, and I do not want to try to parse through a screenshot of a block of text, hoping that I understand it and risk providing you with misguided assistance, which wastes both of our time. Best Practice for question asking:

1. Include detailed description of problem, your inputs, desired output, and how the bits in between ought to work. Ideally, you will include what you have already tried to solve your problem

2. Sample data that includes real (not confidential of course) or dummy inputs and outputs that are representative of you problem in the form of a table or excel spreadsheet

3. (Optional but really great) A .yxmd or .yxzp with your current progress.

 

You can use the Summarize Tool to perform a sum calculation and you can preface that with the Formula Tool to capture conditional logic.

 

Hope this helps and Happy Solving!

GT-GauravDhama
5 - Atom

Can you please share excel file.

Labels
Top Solution Authors